Formula to calculate number of rows occurring in same month on a bar chart?
That title is a bit janky but I wasn't sure how to put it.
Basically I'm trying to do a graph for repairs done by a contractor, and the basic layout for the data is something like
Repair Ref No || Start Date || End Date || Repair Type
I'm planning to plot the graph against the end date as that calendar is already on there (I'm working on adding to pre-made work) but could make a calendar for the start date (And probably will because it makes no sense)
I basically want a count for each month of the number of repairs completed in that month that were started in the same month.