Avg By Month

[dsharmaqv]

Hi I am trying to calculate the avg by month

Data

Table 1

Date	Count	Month
2015-03-11	3	Mar
2015-03-12	6	Mar
2015-03-13	4	Mar
2015-04-05	7	Apr
2015-04-06	2	Apr
2015-04-08	2	Apr
2015-05-12	4	May
2015-05-13	5	May
2015-05-14	3	May
2015-06-01	6	Jun
2015-06-02	8	Jun
2015-06-03	9	Jun

Output

Month	Average Count Per Month
Mar	4.33
Apr	3.67
May	4.00
Jun	7.67

[dsharmaqv]

forgot to mention

I am trying to plot the monthly avg as a line graph and setting 25% monthly avg as a reference line threshold

[sunny_talwar · Accepted solution]

Count is a field? If it is, then may be this

Dimension

Month

Exp

Avg(Count)

[hemachandran]

Hi Deepak,

Use bar chart as

Dimension Month

Measure Avg(Count)

Set reference line..

[rahulpawarb]

Hello Deepak,

Refer attached sample application.

Regards!

Rahul