We’re looking at tracking cycle time of objectives in specific categories.
Do do so we group the CTAs by Objective Category and are able to look at the min and max of the corresponding start and end dates.
Is there a way to do a calculation on the grouped values and calculate the number of days between the start and end days?
Best answer by alizee
Hi
The formula field cannot understand the ‘min’ and ‘max’ aspect of the field in a report. It’ll only offer the non aggregated date fields in the date difference formula.
So while you can’t do it in a report, you can achieve this with a data design before you could display it in a report. That would involve:
+11Hi
The formula field cannot understand the ‘min’ and ‘max’ aspect of the field in a report. It’ll only offer the non aggregated date fields in the date difference formula.
So while you can’t do it in a report, you can achieve this with a data design before you could display it in a report. That would involve:
Thank you
+11Hi
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.