Skip to main content
elaine_cleary
elaine_cleary
Helper ⭐️⭐️
June 25, 2016

Can we create ONE bar chart or line graph that compares data year over year?

  • June 25, 2016
  • 12 replies
  • 176 views
Can we create one bar chart or line graph that compares a single usage data metric, for example, from Jan - June 2015 and Jan - June 2016 overlaid on the same chart?  I'm not looking for two charts side by side but rather for a single chart where I can easily see the trends over specific months compared to each other.  If this is not currently possible, are there plans for adding year-over-year reporting?  Thank you.

      12 replies

      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      June 26, 2016
      Hi Elaine,

      I was trying to think about how to do this and I think we'd have to aggregate by Year and then aggregate by Month. But I don't believe that reporting allows multiple levels of aggregation on the same field. Was that the way you were thinking about how to solve this as well?

      -Dan
      VP of Customer Success at Forcepoint
      elaine_cleary
      elaine_clearyAuthor
      Helper ⭐️⭐️
      June 27, 2016
      Thanks for the comments, Dan.  I don't know how to easily solve year-over-year reporting needs.  Perhaps someone from Gainsight product will have a suggestion...
        gaurav_kotak
        gaurav_kotak
        Expert ⭐️
        June 27, 2016
        I don't believe today you can overlay period comparison on same chart. What you can do is for time-series objects such as Usage data, you can plot time on x-axis, group by quarter, and then do the comparisons. If the data you want to do this on is not presented in a time-series schema, you'll need to copy that over via rules engine to usage data (or some other custom field)
        gaurav_kotak
        gaurav_kotak
        Expert ⭐️
        June 27, 2016
        Time series overlay is something that does make sense to do. We are moving into an architecture to better support multiple queries, that will enable us to do this in future, but no specific ETA
          dan_ahrens
          dan_ahrens
          Expert ⭐️⭐️⭐️
          June 27, 2016
          I tried this out and you're right, Gaurav. If I aggregate by year, it won't let me then aggregate by month. Only one aggregation per data field is allowed apparently.

          This would be cool to do though as it would be ideal for YOY reporting by quarter or month where you could compare bars or lines right next to each other for the same quarter or month but each bar or line representing different years.
          VP of Customer Success at Forcepoint
            samantha_braastad
            samantha_braastad
            Contributor ⭐️⭐️⭐️⭐️⭐️
            October 27, 2017
            Is there an update on YOY abilities in reporting? 
            samantha_braastad
            samantha_braastad
            Contributor ⭐️⭐️⭐️⭐️⭐️
            September 10, 2018
            Any update on ETA? 
              lila_meyer
              lila_meyer
              Gainsight Employee ⭐️⭐️⭐️
              October 1, 2018
              I'm going to switch this to an Idea post for better tracking. 
              Lila Krutel, Dir. Global Education Services
              sagan_sherlin
              sagan_sherlin
              Helper ⭐️⭐️
              December 6, 2018
              I just stumbled upon this - We're trying to find a way to report on our accounts 'entered' this year, compared to last year. For example, Jan - Dec 2018 would be my Bar Chart, and then my Line would be the accounts added int 2017. I've attempted to 'trick' the software - but no success. By chance has someone found a work around for this type of a comparison?

              sagan_sherlin
              sagan_sherlin
              Helper ⭐️⭐️
              September 14, 2020

              Oh a year later and I find myself back at the same post, because this request came up again.  A functional Year over Year, or Month over Month comparison report.

                Show more replies
                Terms & ConditionsAccessibility statement