topic Re: Display measure only when no selection made in App Development

Display measure only when no selection made

deniscamh — Tue, 09 May 2017 14:53:25 GMT

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

Re: Display measure only when no selection made

mato32188 — Tue, 09 May 2017 15:05:43 GMT

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.

Martin

Re: Display measure only when no selection made

deniscamh — Tue, 09 May 2017 15:13:13 GMT

Thanks Martin,

That works