count of workers under each manager rolling 6 months

[Anonymous]

Hi Guru's

i need to calculate count of workers under each manager (Till Date)

.rolling 6 month count of workers where status='Open'

example:up to sep 15    51 workers under  Manager Name 1

              up to Oct 15   55  workers under  Manager Name 2

     etc

Please find the sample application.

Thanks

[robert_mika]

Try:

Create Month  field in script

Month([HeadCount.Start Date]) as Month

Then in Chart use this new fields as dimension

Expression:

count({<HeadCount.Status={'Open'}, [Org Hierarchy.ITSLT Manager]={'Name1'}  >}[No Of Workers])

count({<HeadCount.Status={'Open'}, [Org Hierarchy.ITSLT Manager]={'Name2'}  >}[No Of Workers])

...

the use Accumulate  option

[Anonymous]

Hi Thanks for Your Time

Yearmonth ,Manager are Two dimensions in Line chart

Count(workers) is the Expression

Output example:

Till Feb 2015      35 Workers Under Name1 Manager

Till march 2015   44 Workers under Name 1 manager

-

-

Till Jul 2015   46  Workers under Name 1 manager