Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Is there a way to make a dynamic title/text so that depending on what is selected by the filter changes to title
i.e.
If A is selected in the filter, change the title to "Show A", if B is selected in the filter change title to "Show B"
Thank you
Sure:
You can do sthing like this:
if(len(getfieldSelections(YourDimension))=0,'Show all', 'show '&concat(YourDimension,', ') )
Make a variable in your load-script:
SET vField = GetFieldSelections(filter-field);
Set your title as "=$(vField)" and you are good to go
Yes, you can do it by following,
try this as I mentioned below:-
Expression syntax:
Titles:-
='Sales Per Year' & GetFieldSelections(Year)
SubTitles:-
='Total no: of Sales' & sum(Sales)
Footer Syntax:-
='Total products sold per year' & Count(ProductName)
After selecting the year title will change as below:-
without selection, title will remain as it is:-