Average Time From Resolved to Due Date

Average-time-between-two-date-fields-chart.png

Step 1: Define your Data Source.

Step 2: Choose the ‘Time between’ metric from the available options.

  • Select “Resolved” as the “From date” field.

  • For the “To date” field, choose “Due Date”.

  • Pick a custom work calendar.

Time-between-metric.png

 

Step 3: Switch to Average calculation

Step 4: Display by any relevant field. In our sample, it is ‘Organizations’. The negative result on the chart indicates the average overdue time for this organization.