Count days records per year

Hello,

I'm trying to display for each STATUS the number of days per YEAR in my dataset.

My dataset has EMPLOYEES Category, STATUS and 2 DATES as us can see in the picture.

I can calculate the number of days between the starting and the ending dates but I don't know how to display the number of days per year from 2011 to 2019 for each status.

Any help please

Employee.yxmd

Screen Shot 2019-01-20 at 1.44.34 PM.png

Workflow

Accepted answers

MarqueeCrew

@abdoul,

I solved your challenge by materializing each day in the starting to ending date range. Then I extract the year and now I'm able to use the summarize tool to generate the status, year counts.

I hope that this helps you and demonstrates a technique that you and others can learn from.

Cheers,

Mark

Employee.yxmd

All comments

MarqueeCrew

@abdoul,

I solved your challenge by materializing each day in the starting to ending date range. Then I extract the year and now I'm able to use the summarize tool to generate the status, year counts.