Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a combo chart the represents number of donors and renewal rate by fiscal year.
The renewal rate calculation is: Current Year Active Donors / Total Donors from Prior Year.
When Total Donors from Prior Year is a hard coded field I created in script.
What I need is when there is no selection made by user the chart will display Number of Donors and Renewal Rate but when at least one selection made the chart would display Number of Donors only without Renewal Rate
Please any suggestions?
Before selection
After Selection made
Thanks
Hi Denis,
try this:
Expression:
if(count(GetCurrentSelections()>0), YOUREXPRESSIONwhenSelectionIsMade, YOUREXPRESSIONwhenNoSelectionIsMade)
YOUREXPRESSION should be 0 and then just do not show zero values.
It is dirty solution, but it should work.
BR
Martin
Hi Denis,
try this:
Expression:
if(count(GetCurrentSelections()>0), YOUREXPRESSIONwhenSelectionIsMade, YOUREXPRESSIONwhenNoSelectionIsMade)
YOUREXPRESSION should be 0 and then just do not show zero values.
It is dirty solution, but it should work.
BR
Martin
Thanks Martin,
That works