Summarize by combining rows?

[James_Mills_prologic]

Hhi All

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

James

[James_Mills_prologic]

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 $Timestamp.date() to reference the original Timestamp column and only extract the Date part.