Section access or not ?

[Hakim-A]

Hello,

I have an app showing the results of a survey.

When an user (defined by the variable COMMERCIAL_NAME) connects the app he should be able to see his results but also to compare his results to the total population of COMMERCIAL_NAME

Example : I am user ABC, I open the app I can see the results for me (and the details) and I can compare to the total population without seeing anything more.

When I implement a simple section access of course all the report is limited so I cannot even compare.

Would you have any idea how to achieve this ?

Thank you

[jwjackso]

Create a field that is the total population of COMMERCIAL_NAME, grant all users to the new field.  Everyone will be able to compare their value to the total.

[Hakim-A]

How would you proceed ? Duplicate the data and give COMMERCIAL_NAME the value 'ALL' and then use set analysis ?

Is that your solution ?

[jwjackso · Accepted solution]

Don't duplicate the data, aggregate all users data into 1 field, 'ALL'.  In section access grant user ABC to their data and the new field 'ALL'.  So if you want to compare user ABC's data to the total population

Sum(COMMERCIAL_NAME)/ALL

[Hakim-A]

I see

I'll try to do that

Thanks a lot