Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Count is a field? If it is, then may be this
Dimension
Month
Exp
Avg(Count)
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
Count is a field? If it is, then may be this
Dimension
Month
Exp
Avg(Count)
Hi Deepak,
Use bar chart as
Dimension Month
Measure Avg(Count)
Set reference line..
Hello Deepak,
Refer attached sample application.
Regards!
Rahul