checking syntax for my expression given a variable

[dreweezy]

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.

[tincholiver]

Do you want the graphic to make the graphics according to the selections of those buttons?
have you tried with an adhoc analysis?

[dreweezy]

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.

[tincholiver]

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

[dreweezy]

I see. I think more or less they both function the same but just a different way. 

[tincholiver]

With selectors you do not have to make modifications in the expression, you solve it with show conditional

[sivakumar1994]

Try this and let us know
if($(vSourceFund)= 1, count({<Bucket = {"Source"}>} STATUSES),
if($(vSourceFund )= 2, count({<Bucket = {"Fund"}>} STATUSES),
count( TOTAL <Bucket> count))

[dreweezy]

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..

[dreweezy]

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? 

[dreweezy]

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?