Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please suggest a way if I can remove the filter pane but data still shown for Repeated Users = "Repeated" without doing any changes in Load Script.
So I want to see data relevant to Repeated Users but without having to select the option from filter pane. So even if there is no filter pane, data should only be shown for "Repeated" (filter pane option). Only condition is I do not want to hard code this in script.
Thank you!!
You could use set analysis in you charts, you don't have to have a filter for this field on the sheet.
Sum({$<[Repeated Users = {'Repeated'}>}
You could also create a trigger on the sheet to set the filter to 'Repeated', again you would not have to have a filter pane on the sheet. However, if there is a filter pane for this field on another chart I would recommend using the set analysis.
Jerry, Thanks for the reply.
Your suggestion should work, but when I am writing this ----- Count({$<[Repeated User]= {'Repeated'}>})
It indicates there is error in expression which says "Count takes one parameter only".
Please suggest how should I fix this?
I get that, I did Count({$<[Repeated User]={Repeated}>}[Repeated User]) and it is working
Thank you so much for your help!
You have to mention the field name you are counting on like
= Count({$<[Repeated User]= {'Repeated'} >} DimensionFieldNamehere)