Is that exactly what adhoc analysis does is to give interactivity to the graphics given that it can be assembled according to the selections made by the user both in the dimensions and in the expressions. I know how to achieve it with selectors but not with buttons
Thank you, I have tried but no success. My chart is not showing any data. This syntax should be working because it is exactly what I want to do. I want the count of the status for the bucket - SOURCE when it is selected on button and count of the status for the bucket - FUND when that button is selected and if else show me all - which would be the total.. This really should be working and cannot think what is the issue with this syntax..
New problem that I cannot for the love of god figure out.. the if else statement of giving me the count of all the status are not matching up correctly.
ALL = bucket(Source) + bucket(Fund)
the status numbers are matching up except for one value 'Complete' where it is somehow adding an additional 10. The total should be 250 but it is showing as 260 when I select the 'ALL' button. I have tried excluding the null values and everything. Anyone have have idea?