Skip to main content
New Idea

Rolling 12 Month Report

Related products:None
jean.nairon
kate_green
bill_stevens
jennifer_tolton
  • jean.nairon
    jean.nairon
  • kate_green
    kate_green
  • bill_stevens
    bill_stevens
  • jennifer_tolton
    jennifer_tolton

jennifer_tolton
Is there a reporting date function similar to Current and Next 3 CQ that will show me the LAST 4 quarters of data, monthly?  Something like "Current and Last 3 CQ"?  I need to create a rolling twelve month report, showing data monthly.  Last N Days (365, summarized by Month) is not working for me if I am not running my report as of a specific day.  Thanks!


10 replies

bill_stevens
  • Contributor ⭐️⭐️
  • 3 replies
  • November 22, 2016
A great enhancement would be a "Current and Previous 3 CQ" date filter for reports as that does not seem to be an option today.  

gaurav_kotak
  • Helper ⭐️⭐️⭐️
  • 378 replies
  • November 22, 2016
Thanks for your feedback. You are right Last N Days will only work in this scenario at end of the month. I don't believe we have a way to do this today, but can see the value. Will add this to reporting teams backlog. thanks. 

todd_atkinson
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • 16 replies
  • December 12, 2016
Rather than adding another fixed filter, I would love to see something like "Current and Previous "N" CQ" and/or "Current and Previous "N" Months". Sure would allow for a lot more flexibility.

jennifer_tolton
  • Author
  • Contributor ⭐️⭐️
  • 6 replies
  • January 17, 2017
Any update on when this functionality might be available?

gaurav_kotak
  • Helper ⭐️⭐️⭐️
  • 378 replies
  • February 15, 2017
Hi Jennifer, the Current and Last 3 CQ is planned for Spring Release that will be released in May. While I'm optimistic we're still early in planning cycle. 

kate_green
Forum|alt.badge.img
  • Helper ⭐️⭐️
  • 262 replies
  • January 19, 2018
Hi Gaurav - I don't see this filter in my Gainsight instance.  Was this ever implemented?

kate_green
Forum|alt.badge.img
  • Helper ⭐️⭐️
  • 262 replies
  • January 19, 2018
I am looking for this exact feature.  Did anything get released or did anyone figure out a way to do this? 

lyne_therien
Forum|alt.badge.img+1
  • Helper ⭐️
  • 86 replies
  • July 30, 2019
Any news on this improvement?



We'd like to see Last N quarters, or Last N months. Then we can use date >= Last N quarters (to pick up the current quarter), same for months.



Alternatively, Current and last N quarter or Current and last N months.



Any hope?



thanks!



Lyne



lila_meyer
Forum|alt.badge.img+5
  • Gainsight Employee ⭐️⭐️⭐️
  • 1447 replies
  • January 6, 2020

Converted to an idea for better tracking


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • January 7, 2020

This is now possible with Data Designer (https://support.gainsight.com/SFDC_Edition/View_More_Categories/Data_Designer_(BETA)/About/Data_Designer_(BETA)_Overview) which has “last N quarters” and “last N months” filtering capabilities. 

 

:)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings