AVG of Incidents created every month

[Community Alums]

Hi folks,

I've dashboard - Avg no.of inc's created every month. created using PA.

In month of JAN (31 days) no INC's were created for 5 days, so the result should be (no.of INC's/26) but i've noticed avg as (no.of INC's/31).

How can i get the desired output ?

[AndersBGS]

Hi @Community Alums ,

Why would you like to do this? Even through that that there hasn't been created incidents for the first 5 days, jan is still 31 days. So if you would like the  "Avg no.of inc's created every month." you should utilize the 31 and not 26.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Community Alums]

Our requirement is to match avg values mentioned by client.

can’t we achieve this?

[Community Alums]

Srry my question is wrong,

if i apply BY month AVG filter, it's excluding days when no records are created.

But i want result for whole month. i.e for 31 days