Skip to main content
HollySimmons
Helper ⭐️
July 14, 2021
New Idea

Include "Current and Next X" and "Current and Previous X" filters in Horizon Reporting

  • July 14, 2021
  • 18 replies
  • 248 views

With the move to Horizon reporting some very important filters have been “depreciated” which makes some reporting now impossible. 

In old-style you can choose from lots of “Current and” options; 
 

This is particularly useful for financial reporting and forecasting, e.g. show me all customers renewing this month and next month. 

But with the move to Horizon those options are no longer available, and instead there’s just Last X or Next X, which excludes the current X. 

E.g if I chose Next 2 Months, I see August and September, when what I want is July and August;
 



WIthin Report Builder it is possible to achieve what we want by adding two filters and OR’ing them together, but that doesn’t work for global filters on Dashboards. 

These are really important filters to have available, PLEASE bring them back. 

18 replies

sai_ram
Expert ⭐️⭐️
July 14, 2021

@HollySimmons sorry for the inconvenience. If those are missing in Horizon reporting then it should be a bug. I will check and get back to you. 

bradley
Expert ⭐️
July 22, 2021

@sai_ram it’s also missing in Renewal Center. I brought this up on a call a few months ago with the product team but not sure what came of it. Just noting it in the hopes that if it gets restored in HA that the Renewal Center filters get the same love. I do know for renewal center they added a ‘Next 120 Days’ option for time based filters - just not sure if there is any plan for system wide continuity on how date filter options work...

sacha
Contributor ⭐️⭐️⭐️⭐️⭐️
September 28, 2021

Hi Team! Checking back on this, was it considered a Bug and if so is it getting fixed? It would be great to have the flexibility back that was removed from Horizon Dashboards. Thank you!

dan_ahrens
Expert ⭐️⭐️⭐️
September 30, 2021

@rakesh any thoughts on this one?

VP of Customer Success at Forcepoint
sarahmiracle
VIP ⭐️⭐️⭐️⭐️⭐️
November 8, 2021

We’re preparing to migrate to HA next week and I’m very disappointed to see that this date filter preset is no longer available. Can someone provide a status update on this?

Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member
darkknight
Expert ⭐️
November 9, 2021

+1

Jeff Kirkpatrick
dan_ahrens
Expert ⭐️⭐️⭐️
November 9, 2021

@rakesh - is this something that we can bring back since it existed in the previous version of reporting?

VP of Customer Success at Forcepoint
rakesh
Gainsight Employee ⭐️
Lets put your data to work!
November 10, 2021

Hi All,

We had 64 literals in the old reporting - a lot of which are not needed/add to the complexity. Imagine scrolling through those values to find the right one - especially if you have not yet built the memory. In Horizon Analytics we have rationalized it to 35. As a part of it we consolidated a few literals into one literal with options. (Example: LAST_7_DAYS,  LAST_20_DAYS … LAST_120_DAYS can be achieved with LAST_N_DAYS). 

However, as we did this exercise, it was a known factor that some literals cannot be simplified directly - like “Current and Next X" and will need 2 different filters. We checked the data on how many such filters are configured across all our customers in production and based on how (in)frequently these literals are used, we decided to not rebuild those. The gap that is asked on this thread is basically that.

 

But with multiple upvotes and the usecase with Global Filters, we plan to also add support for the “Current and Next X", “Current and Previous X" literals for Month, Quarter, Fiscal Qtr, Year and Fiscal Year respectively. However, I also want to add that this will take some time since these changes are quite fundamental and will impact multiple product areas. 

Contributor ⭐️⭐️
November 10, 2021

This is essential for us and with the deprecation of the old Dashboards scheduled for January Gainsight will no longer be a tool we can leverage successfully if this is not made possible in the new dashboards. I don’t understand how you can deprecate the old dashboards and reports without ensuring that this functionality is included in the new versions. Additionally, this should have been proactively flagged to the handful of customers that do use these literals so that we weren’t surprised when they disappeared. Companies operate on fiscal quarters, while these may be under utilized filters by Gainsight customers they are highly valuable, with far more operational value than filters like last 30 or last 90. Without this functionality we will be forced to use Salesforce for reports and dashboards and we will very likely leave Gainsight as a customer, as working in two systems to get what we need defeats the purpose of having Gainsight. 

darkknight
Expert ⭐️
November 10, 2021

This is essential for us and with the deprecation of the old Dashboards scheduled for January Gainsight will no longer be a tool we can leverage successfully if this is not made possible in the new dashboards. I don’t understand how you can deprecate the old dashboards and reports without ensuring that this functionality is included in the new versions. 

:100: At a minimum, communicating to your customers when the plan is to deprecate a function.  But agree that this is still a function that is needed.

Jeff Kirkpatrick