Max when use SUM calculation

[MiguelAngelLV]

Hi.

When I use SUM calculation, the max is the same that when I use AVG calculation, so, the most of cells are over the max and I must set the max manually.

[marcusolsson]

I'm afraid I don't fully understand what you mean. Could you give me an example?

[MiguelAngelLV]

Hi. Example:

My values for first hour: 5 + 5 + 5 -> Average 5, Sum 15
My values for second hour: 7 + 3 + 10 -> Average: 6.3, Sum: 20
My values for third hour: 0 + 0 + 0 -> Avarage: 0, Sum: 0

When I select AVG Calculation, the range of values is from 0 to 6.3.

First hour orange, second hour is red and first blue. Perfect!

The problem is con Sum Calculante, the range of values is from 0 to 6.3 too instead of 0 to 20.

So. first hour is red, second is red and third is blue... Not perfect...

[EBZ-Krisemendt]

i hook up on that issue since i got a similar problem with calculation.
no matter which sort of calculation i pick, it does use the last value in that bucket instead

[marcusolsson]

Gotcha! I'll look into this during the weekend to see if I can replicate/fix this!

[marcusolsson]

Unfortunately, I haven't able to replicate this yet. Let me know if my test is different from yours:

[marcusolsson]

Oh, I think I know why this is. The min and max are computed by Grafana from the fields, rather than the aggregation. Does it work if you set the min and max manually?

[MiguelAngelLV]

Yes, works, But... I don't know what is the max and the min . El lun, 7 dic 2020 a las 14:49, Marcus Olsson (<notifications@github.com>) escribió:

…

Oh, I think I know why this is. The min and max are computed by Grafana from the fields, rather than the aggregation. Does it work if you set the min and max manually? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#16 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAE3ZHQK5UG5B7AK5L2OFI3STTMQDANCNFSM4SWMZ3CA> .

-- Miguel Ángel López

[marcusolsson]

Yeah, just wanted to confirm. Max and min should depend on the result of the calculation rather than the raw data. Thanks for clarifying 🙏