topic Excluding data from Graph Based on Value in Discussions

Excluding data from Graph Based on Value

ClusteredTable4 — Sun, 11 Jun 2023 11:29:14 GMT

Is there a way to graph data, if it occurs 2 or more times?

For instance:
Column 1: Family Name
Column 2: Rooms of the House with a Television in it

Is there a way for me to sort and graph my data to only include families with 2 or more Televisions?

Re: Excluding data from Graph Based on Value

jthi — Wed, 09 Nov 2022 16:11:51 GMT

Sure you can. You can use local data filter for example to do the filtering based on count or create calculation column. Below is example using counts

Re: Excluding data from Graph Based on Value

ClusteredTable4 — Thu, 10 Nov 2022 16:04:05 GMT

I apologize for the way I worded my question. I meant is there a way to exclude House-C other than a local data filter. (To keep this reference the same) I have 100 houses, so the local data filter would be very time consuming.

As of now, I changed the x-axis minimum value to 2, but it left a great amount of white space on my graph.

Re: Excluding data from Graph Based on Value

Thierry_S — Sat, 12 Nov 2022 02:07:21 GMT

Hi,

You can Hide and/or Exclude rows in your data table, resulting in excluding these rows in your graph.

You could even split your Column "Rooms with TV" into two new column: 1) Room Name and 2) TV Numbers using formulas

The formula are:

Left (:Rooms with TV, Length (:Rooms with TV) -1

```
Num (Right (:Room with TV, 1))
```

That way you can filter only on the room type and/or the number of TVs.

I hope it helps.

Best,