Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a line chart that I want to show the 3 lines:
1. a team total
2. figure of one person
3. combined figure of all other people in the same team except the selected person
I managed to do the first 2, but couldn't figure out how to do #3 as the selection will change so I cannot hard code the values in the set analysis expression.
qvw is attached. Thanks!
Try Sum({$<Year=, Person=E(Person)>} Hours) / Count(DISTINCT {$<Year=, Person=E(Person)>} Project)
Try Sum({$<Year=, Person=E(Person)>} Hours) / Count(DISTINCT {$<Year=, Person=E(Person)>} Project)
Thanks so much! Exactly what I was hoping to do!