Bypass Section access for a Chart/KPI

[Barry_T]

Hi, 

Maybe I am coming at this the wrong way, but here is the scenario: 

I have a QS app that has a sheet for stats at the user level, there will also be a team level. 

I have used section access to control what information users can see. 

So a user only has access to their own stats, while a manager has access to their teams stats. 

Pretty straight forward so far...

Using a mashup, I have integrated the app into my web app. 

In the Reports section for a user they will have some key stats (KPI) Score & Team Score

I also want to display a user score vs team score over time in a chart on the same mashup.

The issue here is that I cannot see the team score in the KPI or the chart, because the user doesn't have access to the other users stats that make up the team score. 

Is there a way around this? 

Thanks,

Barry

[dplr-rn]

IMO only way is to create another table which would store rolled up values by team.

so that in this table granularity is not by userid

[Barry_T]

Hi, 

Thank you for this suggestion. 

I will talk to the QS guys here and see if I can implement that.

Cheers

Barry