Duplicate hour daylight savings time

[newbie_but_conf]

Hi,

I have a dataset that includes values for each hour of the day. On specifically daylight savings date, there will be 25 hours in a day. This means duplicate hour for 29.10.2023 02:00:00. We have a visual that shows each hour, however obviously the hour when daylight savings is approximately doubled, since it's two hours in one basically. Does anyone know of a way to show 25 hours instead while keeping the datetime column working on all other dates as a slicer?

Thanks!

[newbie_but_conf]

@lbendlin Thanks, but that will just remove one of the values, not add another datapoint, which is what I ideally would like.

[lbendlin]

 not possible unless you switch everything to UTC.

[lbendlin]

instead of sum(value) use max(value)