Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
i'm in trouble with getfieldselection() function. I have created a filter with "Time" as dimension and the possible values that "Time" can assume are: "Year","Month","Week". In the dashboard i also have three different KPI object that are elated with "Year", "Month" and "Week".
I would like that when I click on "Year" from the filter you would see the content of the KPI relating to YEAR, but at the same time I would like that if you selected more Items from the filter (eg Year and month) you would see Year and month at the same time .
I tried to use this expression getfiedselection (Time) = 'Year, Month' but it doesn't work. Can anybody help me?
Thanks,
Petrr
I believe this is what i've done similarly...
Year condition:
Count(distinct {<Time*={'Year'}>} Time) > 0
Month condition:
Count(distinct {<Time*={'Month'}>} Time) > 0
Week condition:
Count(distinct {<Time*={'Week'}>} Time) > 0