I am trying to graph the costs spent on projects per month in th dashboard using the chart widget. The problem is when the project goes into the next year instead of setting the first months spend ahead the last month in the last years spend it moves it to be next to the same month in the previous year as seen in the january months in the below screenshot showing 2024 & 2025 next to eachother.
I am guessing this starts at the report its pulling from that i am also unable to get the dates to align correctly as seen in the 2nd screenshot below.
I tried grouping by mm/yyyy in ascending order but it did not help.
Any input would be appreciated!