Forum Discussion

cwollett's avatar
cwollett
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Data model for Survey data

I work at a school that does class evaluations at the end of each term. I am trying to figure out how best to model and analyze this data and am having some issues with what I thought would be a remo...
Need Help
  • cwollett's avatar
    cwollett
    2 years ago

    Unfortunately the ALLSELECTED option will not work because we will have row level security on the dataset, so the RLS will act as an additional filter. The only way I have found to work around the RLS issue is to create an unrelated summarized table.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
2 years ago

cwollett  Yes, the same measure should work for both. How did you get on with using the ALLSELECTED? Have you solved this or do you still need further guidance? 

cwollett's avatar
cwollett
Icon for Advocate II rankAdvocate II
2 years ago

Unfortunately the ALLSELECTED option will not work because we will have row level security on the dataset, so the RLS will act as an additional filter. The only way I have found to work around the RLS issue is to create an unrelated summarized table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi cwollett ,

    Glad to hear you may have found a solution! If you're sure the issue has been resolved, could you mark this post as resolved? That way, others with similar issues can more easily find a solution and the community can see that the issue has been resolved.
    Thanks, and if you need any further help, please feel free to contact

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    cwollett yes, RLS makes things a bit tricky - there's no way I'm aware to clear the RLS filters without creating a different field.