Experience Builder Line Chart by Date configure to start at beginning of the month

[cat206]

Hi, There doesn't sem to be a way to reconfigure the date field in a line chart to follow the monhs. The first point in my data is 18th Janauary and the rest seem to follow this format. It span from January 2022 to todays date, but when you have a look at the lines it's counting from 18th of each month until the 17th of the next month when really I want, to see 1st to Month end (28th/30th/31st):

Instead, starting 1/1/2022 - 31/1/2022, then 1/2/2022 - 28/2/2022 and so on

If i try to use a bar chart, the data just does not display: