10 Replies Latest reply: Aug 14, 2018 12:53 AM by arvind pednekar

# Showing a graph as blank until a filter is applied

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 ?

• ###### Re: Showing a graph as blank until a filter is applied

Just change it slightly into this:

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

• ###### Re: Showing a graph as blank until a filter is applied

Hi,

Try this

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

Thanks & Regards,

Dhanaji Roman

• ###### Re: Showing a graph as blank until a filter is applied

Try this.

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

• ###### Re: Showing a graph as blank until a filter is applied

Try,

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

• ###### Re: Showing a graph as blank until a filter is applied

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

• ###### Re: Showing a graph as blank until a filter is applied

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

• ###### Re: Showing a graph as blank until a filter is applied

Try this :

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

• ###### Re: Showing a graph as blank until a filter is applied

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

• ###### Re: Showing a graph as blank until a filter is applied

This works, Thanks a ton!

• ###### Re: Showing a graph as blank until a filter is applied

Welcome