How to Calculate average in dashboard report?

[Shubhashis]

I have two fields- request and month. Month as a choice field and in the dashboard I want to show for each month how many requests are created and the month field will work as a filter over here? So, I got a new requirement, whenever I select a month from filter i need to show average for the request in this filtered months? For example, for january 3 requests are there,for february 4 requests are there,for march 2 requests are there,for april 1 requests are there.So, when I select jan,feb,march in filter then average will be  shown as 3.

How to do it?

[Community Alums]

Hi @Shubhashis ,

Generally, Average is taken by using "Aggregation" as "Average" under configure tab.

Here is a report which i created for you:

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Shubhashis]

And if month and year is a string field just like the below screenshot, then can we create the report?

[Community Alums]

No you cannot