Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Reply To: CALL DROP RATE

#48178
pix
Guest

make the same example with a cell with 10 drops and 1000 calls (1%) one day, and 2 drops and 3 calls the next day…

the average doesn’t show the truth at all. The sum is clearly giving you a correct value, that you can work on.

by doing the sum first, you take into account the number of calls, which give a weight based on the traffic.