Summarize function on "seconds" to avoid aggregated data:


I am displaying data from an SQL database and each data has a time stamp with seconds precision. (example: 2021-08-04 10:47:37)
I have often 2 data on the same second and I have the warning message telling me that some data are aggregated and summed.

My goal is to avoid having those data summed, and display either the average of those values which are logged on the same second, or the min or max value.

To avoid this I am trying to use the "Summarize" function when creating a question, using the "max" selection of the data, but in "Group by" I can only select minutes, hours, weeks, day, months etc. but I cannot select seconds.

Can I achieve what I need in another way?

Thanks a lot!

Hi @Lolipop
You would have to use SQL to make grouping by such low granularity: - upvote by clicking :+1: on the first post