Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a drill down which goes year-month-week-day-hour for call logging on duration and count for list of users, and I want to know if its possible to put on reference lines with different values based the level of drill down and the number of staff selected.
So, for example -
with one user selected when viewing by day the duration reference line should be set to 120 mins and the count reference line should be 25
with five users selected in (working) week view the respective values should be multiplied by 25 (i.e. 5 users x 5 days)
I am anticipating that an expression is required but have no idea where to start!
Thanks, Steve
to get the dimension of the drill dow group
GetCurrentField([drill group name])
to get the number of users
GetSelectedCount(userfield)
or GetPossibleCount(userfield)
it should be (post your doc for more detail), a lot of if/and
if(GetCurrentField([.....])='....' and GetSelectedCount(.....)=1, ........,
if..........