How Many employes removed Last 6 Months

[Anonymous]

Hi Guru's,

I have start date,End date,Count(worker),Manager,Month Year

Dimensions:Month Year,Manager

Expression:Count(workers)

Issue:Count of removed Employees in last 6 Month

[robert_mika]

Any chance for your data?(Excel,CSV)

[Anonymous]

here is the data

[settu_periasamy]

I think, your expression is correct. Try to Give the direct field name instead Qualifier field name.

May be like this

count({<MonthName1={'>=$(=Date(addmonths(Max([End Date]), -6))) <=$(=Date(addmonths(Max([End Date]), 0)))'} >} Worker)

[Anonymous]

Hi All,

As per the data last 6 month 48 Employees are removed.

i want to show last 6 Months  in X axis

[settu_periasamy]

Last Six Months mean >=1/1/2015 <=6/30/2015, right?

for me it shows 46, can you provide list of 48 Employees you have?

[Anonymous]

46 is correct,can u post the sample file

so i can implement the same

[perumal_41]

Hi Are Babu,

u can try  expression

=

count({<[End Date] ={">=$(=Date(monthstart(addmonths(today(), -6)))) <=$(=Date(addmonths(today(), 0)))"} >} Worker)

[settu_periasamy · Accepted solution]

=count(DISTINCT {<MonthName1={'>=$(=Date(MonthStart(addmonths(Today(), -6)))) <=$(=Date(MonthEnd(addmonths(Today(), -1))))'} >} Worker)