3 Replies Latest reply on Oct 21, 2018 6:20 PM by lei.chen.0

    Looking for YOY Comparison Ideas

    Kelly Wu

      Hi guys,

       

      I'm looking for ideas to compare YOY data. I'm trying to bringing in multiple years of data and want to allow users to do a YOY comparison based on the date/parameter filter.

       

      For instance, I would like to compare 1/1 - 1/7 data for multiple years. Users are allowed to manually enter the month and day in the date range.

       

      Eventually I would like to display a chart similar to:

      Date Range is 1/1 - 1/7

       

      Category20172018
      Volume10  ---this is a sum20
      Hours1.3  ---this is an average1.1

       

      I do not have the sample created yet but just looking for ideas on how to build this layout. Want to find out if it is possible to do such report? Please provide any ideas if possible. I appreciate your help!