I have the following table, which shows the approval rate of our deposits for every hour of the day. For example the approval rate at 4 AM was 66.67, but the running average is 58.93% (100+28+50+50+66.67)/5. How do I add this value, which I am showing in a chart, that shows both approved, rejected and the running average? For context, the approved % is calculated by the amount of transactions that were approved at a specific hour.
<tbody>
</tbody>
The average approval rate is only based on the approved %, but I can't get it to work, and on the pivot table, I would like that running average to be a 3rd column next to the Rejected column.
The ideal pivot table would look like this:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
| Processor | Approved | Rejected |
| Hour | ||
| 0 | 100.00% | 0.00% |
| 1 | 28.57% | 71.43% |
| 2 | 50.00% | 50.00% |
| 3 | 50.00% | 50.00% |
| 4 | 66.67% | 33.33% |
| 5 | 50.00% | 50.00% |
| 6 | 75.00% | 25.00% |
| 7 | 75.00% | 25.00% |
| 8 | 100.00% | 0.00% |
| 9 | 75.00% | 25.00% |
| 10 | 86.67% | 13.33% |
| 11 | 77.78% | 22.22% |
| 12 | 37.50% | 62.50% |
| 13 | 63.64% | 36.36% |
| 14 | 100.00% | 0.00% |
| Grand Total | 70.18% | 29.82% |
<tbody>
</tbody>
The average approval rate is only based on the approved %, but I can't get it to work, and on the pivot table, I would like that running average to be a 3rd column next to the Rejected column.
The ideal pivot table would look like this:
| Hour | Approved | Rejected | App Rate |
| 0 | 100.00% | 0.00% | 100.00% |
| 1 | 28.57% | 71.43% | 28.57% |
| 2 | 50.00% | 50.00% | 50.00% |
| 3 | 50.00% | 50.00% | 50.00% |
| 4 | 66.67% | 33.33% | 66.67% |
| 5 | 50.00% | 50.00% | 50.00% |
| 6 | 75.00% | 25.00% | 75.00% |
| 7 | 75.00% | 25.00% | 75.00% |
| 8 | 100.00% | 0.00% | 100.00% |
| 9 | 75.00% | 25.00% | 75.00% |
| 10 | 86.67% | 13.33% | 86.67% |
| 11 | 77.78% | 22.22% | 77.78% |
| 12 | 37.50% | 62.50% | 37.50% |
| 13 | 63.64% | 36.36% | 63.64% |
| 14 | 100.00% | 0.00% | 100.00% |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Last edited:
