I have a view that outpus like below. Here the "Date" is actuallly a datetime field. (It stores the datetime as "2022-10-31T05:00:00" in the database)

Username Date Distance
Krishna 2022-10-23 23
Krishna 2022-10-23 25

I need to display the result, group by username, date and "sum" of Distance (as shown below).

Username Date Distance
Krishna 2022-10-23 48

I did use aggregation, but since the date field is actually a datetime field, it's considering the time while grouping and doesn't group the result by date.

How can I achieve this?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.