Forum Discussion

Tatibella's avatar
Tatibella
Frequent Visitor
3 years ago
Solved

My role is blocking my data

Hi everyone,

 

This is the scenario: I have a role for each of the 4 schools according to the ide of the school. Each school should only see its own data, however I have a bar chart where I compare the average grade of a school with the average grade of the 4 schools.

Like this :

78 is the average of one especific school and the 70.6 is the average of the all the four school (by subjet, year, )

However when a user get in the dashboard with an specific school role, he only see the following:

 

 

I am using a measure to calculate the average of four schools.

 

I appreaciate your advice.

Thanks.

 

Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Your role is applied in both measures, so you won't see the expected average values. One option is to add a separate summarized table that is not filtered by your role filter that can be used in calculations for all roles.


    Pat

2 Replies

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Your role is applied in both measures, so you won't see the expected average values. One option is to add a separate summarized table that is not filtered by your role filter that can be used in calculations for all roles.


    Pat