Is there a way I can create a line chart showing the % of CTAs closed within 7 days summarized by week (created date) and filtered by assignee? I feel like the data is there, but not sure how to set up a report to show it in this format or if a custom field calculating the % may need to be created.
Question
Report showing % of CTAs closed within 7 days of being created, by week
+3
+3Hey Katie
I created a Vidyard Video that you can view here, but in order to do this you need a formula field added to the Call to Action object. I believe that there are in report formulas on the report roadmap, but if you are looking to get this done today, this will be the easiest way.
Formula on Call to Action object
https://share.vidyard.com/watch/fyz2s8du8HQc4162tNqAhi
I created a Vidyard Video that you can view here, but in order to do this you need a formula field added to the Call to Action object. I believe that there are in report formulas on the report roadmap, but if you are looking to get this done today, this will be the easiest way.
Formula on Call to Action object
- label= Closed in 7 days
- type = checkbox
- value = IF( JBCXM__ClosedDate__c - JBCXM__CreatedDate__c <= 7, TRUE, FALSE)
https://share.vidyard.com/watch/fyz2s8du8HQc4162tNqAhi
+3That is exactly what I needed. Thank you!
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.