Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=count(DISTINCT {<MonthName1={'>=$(=Date(MonthStart(addmonths(Today(), -6)))) <=$(=Date(MonthEnd(addmonths(Today(), -1))))'} >} Worker)
Any chance for your data?(Excel,CSV)
here is the data
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)
Hi All,
As per the data last 6 month 48 Employees are removed.
i want to show last 6 Months in X axis
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?
46 is correct,can u post the sample file
so i can implement the same
Hi Are Babu,
u can try expression
=
count({<[End Date] ={">=$(=Date(monthstart(addmonths(today(), -6)))) <=$(=Date(addmonths(today(), 0)))"} >} Worker)
=count(DISTINCT {<MonthName1={'>=$(=Date(MonthStart(addmonths(Today(), -6)))) <=$(=Date(MonthEnd(addmonths(Today(), -1))))'} >} Worker)