Report Completed by Due Date

  • 2
  • Question
  • Updated 1 year ago
  • Answered
Our leadership team wants a report to show 2 things:
1. Total CTAs Completed
2. Total CTAs Completed by Due Date

Currently, we're just exporting the raw CTA data from GS into Excel or into Tableau reports. Has anyone created a similar report directly in GS?  Is it possible?
Photo of Heather Hansen

Heather Hansen, Champion

  • 8,774 Points 5k badge 2x thumb

Posted 1 year ago

  • 2
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,434 Points 20k badge 2x thumb
Hi Heather, is this along the lines of what you are trying to accomplish?
Photo of Heather Hansen

Heather Hansen, Champion

  • 8,774 Points 5k badge 2x thumb
Here's an example:
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,434 Points 20k badge 2x thumb
So basically what you need is a formula field that tracks the number of instances where the close date was later than the original due date, right?
Photo of Heather Hansen

Heather Hansen, Champion

  • 8,774 Points 5k badge 2x thumb
Yes please.  :)
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,434 Points 20k badge 2x thumb
So there are a number of fields that you could use to measure if a CTA was overdue:


But unfortunately you won't be able to create that visualization that you have in the sample with the mix of 1 column data and two line data sets. 

You could represent the data visually with a different visualization (3 columns for example) and use an MDA table to store the data. Use the new formula field feature in bionic rules to calculate the number of CTAs that were closed and overdue. 
Photo of Manu Mittal

Manu Mittal, Employee

  • 13,004 Points 10k badge 2x thumb
This is probably the closest we can come when reporting directly on the Call To Action object:

      
      

For example, in July 2016, we completed a total of 686 CTAs, with 312 (45.48%) closing on time and 374 (54.52) closing overdue (after the due date). 'Closed Overdue' is calculated using 'Due Date', but we could create a new formula field that calculates on 'Original Due Date' instead.

      
Photo of Heather Hansen

Heather Hansen, Champion

  • 8,774 Points 5k badge 2x thumb
So, I don't have a Closed Overdue field as an option in the Call to Action.  Is that something that we'll have to create on our side first?
Photo of Scott Morris

Scott Morris, Alum

  • 6,312 Points 5k badge 2x thumb
It looks to be a standard field as part of our package.  If you wanted to make it yourself, you can use this formula checkbox syntax:

IF( JBCXM__ClosedDate__c > JBCXM__DueDate__c , TRUE,FALSE)
Photo of Manu Mittal

Manu Mittal, Employee

  • 13,004 Points 10k badge 2x thumb
It's standard, as Scott mentioned. Most likely a permissions issue. Would you be able to edit our permission set, grant access to this field, and retry?