Hello,
I am facing an issue with one of my formula indicator that I have implemented.
The indicator is called "Average Age of Closed Tech Assessments Tasks" with formula ([[Summed Duration of Closed TATSK Tickets]] / [[Number of Closed TATSK Tickets]] / 24) || 0
I am sharing the indicator scores for these two indicators. Assessment Type is the Breakdown and these indicators collect data in a Daily Collection job.
My math says that lets say for Assessment Type = Accessibility, the score should be 6.78.
Summed Duration of Closed TATSK Tickets:
100 + 2031 + 1153 + 622 = 3906
Number of Closed TATSK Tickets:
3 + 8 + 7 + 6 = 24
Score for formula indicator = 3906 / 24 / 24 = 6.78125
However when I view this indicator on my dashboard using "BY WEEK AVG", it shows 3 days as below
My math says that this is happening because PA is averaging everyday:
| Date | Summed Duration (Hours) | Number of Tickets | Daily Average (Hours)[Duration / Count] | Daily Average (Days)[Hours / 24] |
| May 18 | 100 | 3 | 33.33 (100/3) | 1.39 (33.33/24) |
| May 19 | 2,031 | 8 | 253.88 | 10.58 |
| May 20 | 1,153 | 7 | 164.71 | 6.86 |
| May 21 | 0 | 0 | 0 | 0 |
| May 22 | 622 | 6 | 103.67 | 4.32 |
| May 23 | 0 | 0 | 0 | 0 |
| May 24 | 0 | 0 | 0 | 0 |
Resulting into ~3 days.
