I am aggregating different values by month in my data. Afterwards, I use the aggregated data in a highchart where I encounter some problems with date time formats. However, this only occurs when I filter my data frame on the date before I aggregate - no filter no problem.
Without the filter, the x-Axis looks like this:
With the filter, the x-Axis looks like this:
It only happens when I select a date range within one month. Thus, if I select dates from Nov. 1st 2020 to Dec. 3rd 2020 its fine. If I select dates from Nov. 1st to Nov. 30th I experience the issues.
Does anyone have any experience with this or has an idea how to tackle this?
Thanks in advance