Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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:
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.
Perhaps like this: Count({<Course=, WIN_LOSE={1}>}EVENT_ID)
Perhaps like this: Count({<Course=, WIN_LOSE={1}>}EVENT_ID)
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.