question

Wai C. avatar image
Wai C. asked ·

How to change aggregation of metrics in NAM?

For Example, I look at the chart of HTTP 404 error using last 3 month with monthly resolution.


So what I see are 3 bar, where each bar shows the SUM of HTTP 404 error for that month.

What if I want each bar to show AVERAGE HTTP 404 error per day instead of SUM?


I know I can knew the answer by change the monthly resolution to daily resolution to see 30/60/90 bar. But right now I need to achieve this by 3 bar only.


Best Regards,

Wai Keat

configurationdashboardreportsNAM 2018nam 2019
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jacek J. avatar image
Jacek J. answered ·

Hello,

I like Kris idea with calculated metrics, and here's example simple implementation:

Average HTTP errors per day metric is just a calculated column, my formula is very simple, it's just dividing sum of errors by 30, as shown below:

Whole report's definition in attachment: AVG daily HTTP errors per month.zip


1.png (31.0 KiB)
2.png (12.6 KiB)
Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Kris Z. avatar image
Kris Z. answered ·

If I understand you correctly, you need to divide the number you have by number of days in a month. If this is correct, then it looks like a custom metric definition.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.