We want to create a formula field on a report that indicates if the modify date on a Success Plan is greater than a certain amount of time. This is intended to use to help identify more easily Account Plans that need to be actioned on.
Formula allows string, number, and date but not Case so we can add a Boolean like we can in Data Designer. Would be great to be able to have this functionality in GS
+1Hi Andrea,
That's an awesome use-case. The current row-level formula does not support comparisons such as If, Case, etc.
We will be working on improving the formula capability in reporting in our medium-term horizon.
This would be really useful for us as well - we have many reports that are grouped by ‘% of users who have done x’ at a company - leading to a really messy report. We could use a case statement/boolean formula field to instead group by ‘over target’ and ‘under target’, letting us keep exec-level reporting in GS instead of moving to another tool like Tableau. Any update on this idea?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
