Is there a way to make a dynamic title/text so that depending on what is selected by the filter changes to title
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"
You could use GetFieldSelections in a dynamic title.
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:-
='Sales Per Year' & GetFieldSelections(Year)
='Total no: of Sales' & sum(Sales)
='Total products sold per year' & Count(ProductName)
After selecting the year title will change as below:-
without selection, title will remain as it is:-
Retrieving data ...