Allow "group by" week/month/quarter/year to work for future dates
CS Reports & Dashboards
Currently if you have dates that are in the future and you select "group by" month/quarter/year, etc., it doesn't show future dates regardless of chart type. If you want to show future dates, you cannot group the dates.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
When you group by month/quarter/year without a date filter, we display data for current + previous 12 months by default. If you explicitly apply a filter that includes future dates, you should be able to report on data in the future dates
Please let me know if this doesn't solve the issue.
Thanks,
Sumesh
Doesn't return all future dates with a simple "greater than" filter.
Best,
JP
Including future dates in monthly summarization is already the case in case of reports built on MDA data. For SFDC we implemented the current behavior (current + previous 12 months for monthly summarization and 12 weeks for weekly summarization etc) due to the technical constraints on SFDC side. We will revisit the constraints and check the possibility of extending the behavior in MDA to SFDC data. We will need a weeks time to revisit and evaluate all the options again. We will get back to you with a definite answer after that.
Thanks
Venky