I have set up a main dashboard of a list hospitals, and the managers can assess this, but they also wanted certain users just to see a particular hospital.
So I achieved this using Section Access, the problem is they want to get a Mean Values of the hospitals,
So I can put this into the main dashboard no problems
the problem is for the people set up under section access the values aren't seen properly because the mean value is just taken on that particular hospital and not the over all?
So for example the below code work on the main dashboard but once the section access kicks in the figure changes.
=count(NEWKEYID)/Count([Hospital Group])
So I need these values to stay the same in the section access,
Section access removes the excluded data so there is no way write an expression that applies to the entire data set when the data is reduced. You may be able calculate the means values in the load script and make these available to all users.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
