I'm not sure if my question title does explain my issue but I will try to explain it in detail.

We are creating dashboards which include staging reports created with data from Zoho Desk.

The main report on these dashboards has a bar chart which shows the stages (statuses) of the tickets which have taken a specific amount of time to complete (for example over 72 hours for the Logistics department) in the last 3 months / last 3 quarters etc.

Normally these reports do only show a snapshot of the latest duration span. I want to create a "Change over Time" or "Trend Line" graph which will show a trend line for particular stages where the snapshot of each particular day data on the line will be calculated based on the daily average from the total value of the target stage's last 3 months (or another specific time range). Let's say that we are using a relative time range of "Last 1 month" for the daily average value points on the line for the stage "Delayed Shipment". In that case, the total value on the "1st of July" point (and consequently the daily average value) will be calculated from the "late completion" sum of the days between 1st of June and 1st of July for that particular stage. The total value on the "2nd of July" point will be calculated from the "late completion" sum of the days between the 2nd of June and 2nd of July and so on.

This will create a dynamic report instead of the static nature of the main report on the dashboard which tells the "late completion" trend (or "change over time" data) over a specific time range for a specific stage (status). We may create different time range versions of these trend lines to see the long term, mid term and short term "late completion" trends of these stages.

I'm asking if it's possible to create formulas to get a daily average for staging time values taken from a specific time range and then if we can create a trend line based on these daily average time values.