Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Lets say I want to have a Country filter that I want to affect two charts on a sheet but not the third chart. Can that somehow be defined in the application?
Lets consider the following uploaded tables:
Sport_Table:
Country Sport
USA Basketball
USA Hockey
Canada Basketball
Canada Hockey
Athlete_Table:
Country Athlete
USA Bill
USA Julie
USA Miguel
Canada George
Canada Jill
My understanding is that if I load these two tables and create an "association" (connecting the two circles) between the two tables, there will exist one Country filed that will control all charts that uses an of the fields in the two tables.
If I don't create an association, then the second table will have the Country field renamed to Sheet1-1.Country. In this case, a filter with the Country dimension will only filter tables that include either the Country field or the Sport field. Likewise a filter with the Sheet1-1.Country field will only filter tables that include either the Sheet1-1.Country field or the Athlete field.
What if I wanted to do both?
What if I want the country field to affect both Sports and Athletes in two of the charts, but for visualization purposes I want a third chart that isn't affected by filters?
The only way I can think to do it would be to load the tables twice. One pair would have an association made, while the second pair would not. Or, perhaps I can create a dummy variable that links the two together? I'm not sure how that would work.
Thanks!
In the Set Analysis statement, {<Field=>} says that Field will ignore any filters on Field. You could have one or more fields in the Set Analysis statement, {<Field1=,Field2=,Field3=>} and the expression would ignore filters on those fields.
You could use an Alternate State in the chart that should not be affected by filters. Or if you are using Set Analysis in the third chart, you can have the Country ignore filters.
Count({<Country=>} Sport)
@jwjackso
Thanks! The alternate state method looks promising.
As for the second method, it works, but I don't understand the syntax or how it applies to the chart. Can you explain that?
What if I just wanted to have a Country column and a Sport column. Since I don't have a Count of Sports column, I wouldn't be able to apply the {<Country=>} piece that seems to be overriding the country filter.
Is there a way to write that into either the Country or Sport dimension?
Edit: I did figure out how to disconnect multiple multiple filters by using commas:
Count({<Country, Sport, Athlete=>} Sport)
In the Set Analysis statement, {<Field=>} says that Field will ignore any filters on Field. You could have one or more fields in the Set Analysis statement, {<Field1=,Field2=,Field3=>} and the expression would ignore filters on those fields.