Annual Trend Graph Not Sorting Properly

Hi Anonymous - 
I agree with Amit in that I would always add in a Calendar dimension as it makes things a lot easier.
In the case of my own Lost time report, I'm just using a calendar months dimension and joining that to the month of the start of the absence.

The quesiton is - how are you expecting to see this data presented on the chart?

So for an absence that started on say 15 April 2022 and lasted until 15 May 2022 - do we:
show a lost time day for each day of that period or
show a 30 day loss against 15 April or
show a 30 day loss against 15 May?

Generally because lost time can extend across months and because you can have open items that are still accumulating days, I report on a single YTD figure for lost time in days - for the monthly amounts I report on the Count of incidents, counted against the start of the absence.

Maybe the right answer is a bubble chart wher the marker for the month of absence is sized accroding to the length of absence, but again based on the start date of the absence - in temrs of aocating it to a month.