Summarize by combining rows?

Hhi All :wave:

I have a table that I imported from a CSV dataset that has a Date/Time column with the full date and time in 1/2hr intervals. See screenshot.

I’d like to create a summary table of this data and combine the rows by day, summing the value(s).

How would I go about doing this?

Kind regards


Answering my own question. On the original data, add a new column with a Date type and make it a formula. Use a formula of $ to reference the original Timestamp column and only extract the Date part.