Count on other datefield then mastercalendar

[#1]

Hi,

I have a question about my case. I have a persons fact table in my HR dashboard. I created a record per day for every person, so I can get a great view per day.

Now I want to make a count of the exits per month. Of course I can make a diffrent table and display it in a chart, but is there a better / easier way?

In this recordset example I have 0 exits in Januray, but 1 in February. After the exit date there are no records for Peter anymore.

MasterDate	Name	ExitDate
31-01-2014	Peter	03-02-2014
01-02-2014	Peter	03-02-2014
02-02-2014	Peter	03-02-2014
03-02-2014	Peter	03-02-2014

Am I clear? Hope so!

[mato32188]

Hi Arno,

not sure, how to do it straight in your chart, but there is an option to make a flag in script:

if(MasterDate=ExitDate, 1, 0) as @CountExit and use expression sum(@CountExit) for MasterDate dimension.

BR

Martin