topic Re: Section access or not ? in App Development

Section access or not ?

Hakim-A — Wed, 02 Jun 2021 11:41:42 GMT

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

Re: Section access or not ?

jwjackso — Wed, 02 Jun 2021 13:18:27 GMT

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.

Re: Section access or not ?

Hakim-A — Wed, 02 Jun 2021 13:27:01 GMT

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

Is that your solution ?

Re: Section access or not ?

jwjackso — Wed, 02 Jun 2021 13:36:58 GMT

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

Re: Section access or not ?

Hakim-A — Wed, 02 Jun 2021 13:40:29 GMT

I see

I'll try to do that

Thanks a lot