6 Replies Latest reply on Sep 21, 2017 12:48 PM by P R

    calculating total average utilization per month

    P R

      Mac 9.2 (customer still uses 9.2)

       

      I have some data and the utilization % is already calculated when I receive the data. I just need to show total average for each month via a line chart. One line for 2017, and one line for 2016 on the same chart.  (see attached ppt example).

       

      The problem is I am stuck in the very first part and can't get the months to display properly.

       

      First step:

       

      1. I need to display months across on columns (Jan, Feb, March, etc)

       

      Then:

       

      2. Show the total average utilization % for each month for 2016 as a line chart

      3. Show the total average utilization % for each month for 2017 as a line chart

       

      Thank you!