DIFOT Dashboard

Hi Experts
I am trying to create a DIFOT dashboard and need some help
I need help with creating a Performance Score Overview, what that is when I click on Oct, it shows how many lines were late by 1 day, how many lines were late by 2 days and so on, then another Performance Score Overview and it shows how many lines were early by 1 day, how many lines were early by 2 days and so on
Then something that shows in month how many average days late and one more that shows on an average how many days early

I need it in pivot table, so when I click on a month it only shows the data for the month
How do I link the timeline to a slicer? So, when I click on a month in the timeline it only the days for that month in the slicer?
How do I add a year pivot table, so I can click the year, then the month and then the day?
I have tried to create pictures of what I am trying to achieve in the attached excel file

Thanks in advance
Rahul

Hi dflak
Thanks for that, the helper coulumns work

Can you help with creating a Performance Score Overview, what that is when I click on Oct, it shows how many lines were late by 1 day, how many lines were late by 2 days and so on, then another Performance Score Overview and it shows how many lines were early by 1 day, how many lines were early by 2 days and so on
Then something that shows in month how many average days late and one more that shows on an average how many days early

Thanks

Hi dflak
I need to use Columns Q & R please

Thanks

Hi dflak
Thanks for that

It's awesome. I will work on the layout

Thanks for your help

Just a question, the below formula works, but shows #N/A, what do i need to change to show the blank results as 0

=IFERROR(VLOOKUP(B58&"",Pivots!$J$4:$K$15,2,FALSE),NA())

Thanks
Much Appreciated
Rahul