Hello,
I need to create a dashboard with several indicators, and for some of them, I need to compare the values of one or more establishments chosen by the user with those of the entire group.
For a single establishment, I have no problem: I have added a query with a prompt for the chosen establishment that I retrieve later, and I use a “where” clause for the indicators. But if the user chooses more than one establishment, all the formulas give me “multiplevalues,” which makes sense.
I tried using a variable with the codes of the selected establishments with “inlist,” but it doesn’t work.
Am I required to create one query for the group and a second one for the chosen establishments?
Thank you for your help!