For any data people here, I have a question about how to present some data.

I've got a query that returns periods of vacation time for a group of people, over many years. (5 in this case).

It also identifies when theirs a stat day.

​

So my data for example looks like. This would be 1 row of data.

startdate - 2018-01-01 00:00:00.000

enddate - 2018-01-02 00:00:00.000

count of members - 2

Stat Day found (within that range) - Y

​

I'm trying to figure out how to compare 2018 to 19 to 20 to 21 etc.

How would I best display this?

​

My end goal is to hopefully be able to use this to say, for example, 2nd week of February you typically have X members off on vacation. So a manager could prepare.

​

The problems i'm having figuring this out, is that every year moves everything forward a day, and you can't just add those movements so they all balance out, as that day that was in week 1 of month might be part of week 2 now, but the stat fell in week 1 regardless and thats the week people might take off.

​

I hope this makes sense. Thank you so much for your time.