Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Just change it slightly into this:
Count( DISTINCT [LRM-MVS-Relo] ) = 1
Hi,
Try this
if(GetSelectedCount([LRM-MVS-Relo])=1 ,1,0)
Thanks & Regards,
Dhanaji Roman
Try this.
GetSelectedCount([LRM-MVS-Relo])=1
Try,
If(getselectedcount([LRM-MVS-Relo]) = 1,1,0)
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
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
Try this :
='Sales and Discount by Region for'&GetFieldSelections([LRM-MVS-Relo])
='Sales and Discount by Region for '&GetFieldSelections([LRM-MVS-Relo])
This works, Thanks a ton!