Count days records per year

[abdoul]

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 :)

[MarqueeCrew · Accepted solution]

@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

[Thableaus]

Hi @abdoul

Here's the solution that I thought.

Cheers,

[abdoul]

That's exactly what I was looking for. Thanks @MarqueeCrew :)

[abdoul]

Your solution is also correct and shorter. Thanks @Thableaus