How can I have a dashboard compare "me" (the logged in user) to the average of all users?
Before LOD calcs this was much harder and using row level security lets you limit to the logged in user. For this example I am:
- using superstore data
- a parameter called 'Who am I?' stands in for the username() function
- the 'Segment' dimension is standing in for the field with usernames in it
- We are going to compare my (ie. the 'Corporate' segment) to the average of all the segments.
- Then a version where we exclude me from the average.
|Average for all Segments|
|This version excludes "me" from the average|