I have a filter with two KPIs: for simplicity let’s call it “Ratio A” and “Ratio B”.
Users are set on RSL
I want to create a filter (with parameters) that gives a default KPI based on their RSL.
So for example if Bob has access only to Healthcare sector it would see as default parameter the “Ratio A” (but He would still have the option to select “Ratio B”).
Viceversa for Billy that has access to Car sectors.
What I tried to do is:
- creating a calculated field into the dataset called "Default Ratio", with ifelse statment: assigning the Ratio A and Ratio B according to the sector.
- I then created a parmeter: click on dinamic default: I select the dataset, I assigned the sector column to group column name, and the Default Ratio to column for the default value.
- I also stated “Ratio A” and “Ratio B” in the text box field of the parameter values.
It does not seem to work, could you please help me?
Also, I don’t really understand the difference between Group Column Name and User Name Column
Can I use them interchangeably for my example?
Also please be aware that I don’t have the user name in my dataset. User, belonging to a specific sector, are stated on RSL, They will see only the data belonging to their sector.