Formula Calculations in Reports 2.0
CS Reports & Dashboards
It would be beneficial for Reports 2.0 to have simple formula calculations available such as +, -, SUM, AVG, %. An Example where this would be helpful is with Email Logs. We have sent a survey and within Reports we currently can't report on the "Outstanding" surveys. If we could create a report with a formula that allows us to subtract completed from sent we would be able to get this data.
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.
Thanks for the feedback. One follow up question. Are both "Completed" and "Sent" columns in the same object?
Thanks!
Thanks!
Matt
Created Date - Closed Date
That average would be calculated on the fly from two measures grouped by one of the dimensions above for example.
Also I found another Idea post similar, if not same to this one which is in "Planned" state, but last comment there is 8 months ago.
https://community.gainsight.com/gainsight/topics/formulas-in-reports-2-0
Any update on this?
Thanks
Venky
The Report Builder now offers a new functionality called Formula Fields. With Formula Fields in Reporting, admins can instantly create a formula field in Report Builder, based on their business requirements. These reports can then be consumed in all other functionalities of Gainsight, like: Dashboards, C360/R360, Success Snapshots, etc.
Currently, in Gainsight, admins can also create Formula Fields in Rules Engine and Data Management, and can use them in reports.
You can create Formula Fields of String, Date and Number Data Types.
Formula fields can be applied only on MDA objects and you cannot create formula fields on the following objects: Email Logs, Email Raw Events and Unsubscribed Emails.
Please follow this article for more information.