Question
Is it possible to create a report on a calculated field?
We have a field in the MDA that gets updated everyday with a clients monthly active users number. We have a CTA that gets trigerred when their MAU increase by over 10% month over month. We also want to create a report that shows a list of all our clients that has had a 10% increase in MAU month over month. Is there a way to create a report like this with a calculated field?
+9Hi Berin,
We don't currently have a way to recreate the calculated fields in reports, however you can use the rules engine. You'll need to write the data to an object in order to use it in a report. Depending on the structure of your data in the MDA, you could create a new field on your object and use the rules engine (Load to MDA action type) to load the value to this field. Once you have that data available in MDA, you can filter on customers that had a 10% increase.
A few questions to consider - How is your data currently structured in the MDA? Do you have one record / account / month or does each account have several records?
Let me know if this helps and happy to help troubleshoot!
We don't currently have a way to recreate the calculated fields in reports, however you can use the rules engine. You'll need to write the data to an object in order to use it in a report. Depending on the structure of your data in the MDA, you could create a new field on your object and use the rules engine (Load to MDA action type) to load the value to this field. Once you have that data available in MDA, you can filter on customers that had a 10% increase.
A few questions to consider - How is your data currently structured in the MDA? Do you have one record / account / month or does each account have several records?
Let me know if this helps and happy to help troubleshoot!
+3Alternatively, since you are already generating CTAs for all such customers, you could just build a report on the CTA object and pull in the names. Would that work for you?
Thank you both! Will try that option
Also do you know if this can be added as a product request?
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 E-mail address. We'll send you an e-mail with instructions to reset your password.