Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a variable with 3 buttons that should change my 2 charts based on these buttons.
Button 1: Source
Button 2: Fund
Button 3: ALL
--
Chart 1: bar graph to show me the count of statuses pending given the selection of a button
if(vSourceFund = 1, count({<Bucket = {"Source"}>} STATUSES),
if(vSourceFund = 2, count({<Bucket = {"Fund"}>} STATUSES),
count({<Bucket> count))
I know my syntax is incorrect but I am trying to achieve the count given the buckets of Source or Fund. And if "ALL" button is selected I want it to count all the buckets. Any thoughts? Thank you.
Do you want the graphic to make the graphics according to the selections of those buttons?
have you tried with an adhoc analysis?
Yes, I'd like to render my charts based on my expression/syntax. Not looking for ad-hoc analysis as I am trying to make this dashboard interactive as possible.
I see. I think more or less they both function the same but just a different way.
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..
Ok -- i figured it out.
if($(vSourceRequestor)= 1, count({<Bucket = {"Source"}>} STATUS),
count({<Bucket = {"FUND"}>} STATUS))
When I configured my expression like this it works fine. But how do I incorporate the if else "show me all" part?
Ok, so to update I was able to incorporate the if else part to show me 'all' which is essentially the sum of my 2 buckets of source and fund.
if($(vSourceRequestor)= 1, count({<Bucket = {"Source"}>} STATUS),
if($(vSourceRequestor)= 2, count({<Bucket = {"Fund"}>} STATUS),
count(STATUS)
)
)
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?