Showing a graph as blank until a filter is applied

[mhapanka]

I have a graph in which I have Region as Dimension & Sales as measure. I want to show this graph as blank unless one filter on LRM-MVS-Relo is applied.

In the add-on section, data handling, I used the formula:

count(distinct([LRM-MVS-Relo])=1)

and have displayed the message in it saying select one from LRM,MVS or relo.

However this is not showing blank. Can someone correct me if my logic is wrong ?

[petter]

Just change it slightly into this:

Count( DISTINCT [LRM-MVS-Relo] ) = 1

[dhanaji_roman]

Hi,

Try this

if(GetSelectedCount([LRM-MVS-Relo])=1 ,1,0)

Thanks & Regards,

Dhanaji Roman

[rangam_s]

Try this.

GetSelectedCount([LRM-MVS-Relo])=1

[shraddha_g]

Try,

If(getselectedcount([LRM-MVS-Relo]) = 1,1,0)

[arvind1494 · Accepted solution]

If you want to show that graph at only one selection then use this:

GetSelectedCount([LRM-MVS-Relo])=1

And

If you want to show that graph on  selection in that field then use this:

GetSelectedCount([LRM-MVS-Relo])>0

[mhapanka]

Thanks so much!

I also want the part after "for" in the title to change according to what is selected. I have written something like:

='Sales and Discount by Region for' & if Count( DISTINCT [LRM-MVS-Relo] ) = 1 Concat count(distinct[LRM-MVS-Relo]

How can this be corrected to show me the Selected item/items after "for" in the title

[arvind1494]

Try this :

='Sales and Discount by Region for'&GetFieldSelections([LRM-MVS-Relo])

[arvind1494]

='Sales and Discount by Region for    '&GetFieldSelections([LRM-MVS-Relo])

[mhapanka]

This works, Thanks a ton!