Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ricardodeano
Contributor II
Contributor II

Ignore filter pane selection when multiple charts on sheet

Good afternoon

Very new to this so please excuse my ignorance.

I am currently playing with a horse racing data set and on a sheet, I have two filter panes: course, distance.

Also on the page I have a pie chart that uses the following set analysis to the results by favouritism rank:

Count({<WIN_LOSE={1}>}EVENT_ID)

So for example, if I want to look at the at the % of favourites who have won in a group 1

race at Ascot, I see the following:

Ascot.PNG

What I would like to do is have another comparative pie chart alongside this which effectively excludes the course filter and displays group 1 wins for all courses i.e. ignoring the course selection so effectively this chart would be produced along side the above example:

All Courses.PNG

Is this possible? I suspect it would be but may involve changing the set analysis on one of the charts to ignore the course filter.

Any help, gratefully received.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps like this: Count({<Course=, WIN_LOSE={1}>}EVENT_ID)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Perhaps like this: Count({<Course=, WIN_LOSE={1}>}EVENT_ID)


talk is cheap, supply exceeds demand
ricardodeano
Contributor II
Contributor II
Author

Hello Gysbert

You are indeed correct. I knew it was going to be simple and now I feel like an idiot. Thank you very much for your help and have a great weekend.