I've a requirement to count a record by range based.
EMP StartDate EMPname Status
01 02/01/2014 ABC Available
01 03/01/2017 BCD Offline
In above scenario the fact has 2 entry for EMP01 for 02/2014 and 03/2017
So if I do counts it will come as 2.
But he is available through out 02/2014 till 03/2017.
So if I select 01/2015 or 05/2016 he should still be counted in that month.
My Fact is linked to master based on Datekey which is 20140201 and 20170301
I need to calculate based on range and also count him from 2014, 2015, 2016 and 2017 till March 01.
If I select any year or any month in between 2014 and 2017 I should get an entry, which I'm not getting now.
Can someone please help me calculating range based?
Can you try this?
sorry, can you post and example script based upon my given example?
I'm doing this Int Match based on that link..but it would be helpful if you give an example?
Let's consider for 1 Year data in your sample calendar. Is you have 365 dates then what are you expecting the value for count of Employee?
It should be one.
But for any month or year he should show 1 record in front end.. I can take distinct count
But there are only 2 entries in fact from 2013 to 2017 and he was also available in 2014, 2015 and 2016 and dates don't show.
so for each year or month he should be counted as 1 until 2017