cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Excluding data from Graph Based on Value

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? 

3 REPLIES 3
jthi
Super User

Re: Excluding data from Graph Based on Value

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

jthi_0-1668010261531.png

jthi_1-1668010271647.png

 

-Jarmo

Re: Excluding data from Graph Based on Value

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. 

Thierry_S
Super User

Re: Excluding data from Graph Based on Value

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:

  1. Left (:Rooms with TV, Length (:Rooms with TV) -1
  2. 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

Thierry R. Sornasse