Is there a way to graph data, if it occurs 2 or more times? For instance: Column 1: Family NameColumn 2: Rooms of the House with a Television in itIs there a way for me to sort and graph my data to only include families with 2 or more Televisions?
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
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.
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,
TS
