HOW TO GET AVERAGE BASED ON MONTH

[Anonymous]

Hi,

I have a sharepoint list data source, which has the following columns, i want to calculate average based on month, below i have shown only for one month but there are other months as well

AA=8

BB=15

AVERAGE=(8+15)/2

date      Employee           Projects hrs

10/3       AA                         2

10/3       BB                          5

10/4       AA                         3

10/4       BB                         4

10/5       AA                        3

10/5       BB                         6

[jthomson · Accepted solution]

averagemeasure = divide(sum([projects hrs]),distinctcount([employee]))

This'll work overall, put the date in a matrix/table and navigate to a month by month level

[Anonymous]

It worked!!,....thanks for helping me out