What I want is (for example) if my data came in like this:
Time | Val 2022-05-12 20:50:00 | 1 2022-05-12 20:55:00 | 2 2022-05-13 20:50:00 | 4 2022-05-13 20:55:00 | 10
I want it to be transformed to look like this, such that the it is grouped by
Time (ignoring the time part of the timestamp), and summed on
Time | Val 2022-05-12 | 3 2022-05-13 | 13
I have the following data table:
I added a data override, which successfully gets rid of the HH:MM:SS from the timestamp, and tried a ‘group by’, but it does not group any of the data.
I also tried converting the timestamp via a transform, which did not work:
How can I accomplish the the timestamp reformatting and the grouping?