1 Reply Latest reply: Mar 10, 2015 1:55 PM by Massimo Grossi RSS

    Using varying reference lines with different levels of a drill down

      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