Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Grouped by 1 field

Solved
Jump to Solution
104 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Oleg_77
4 - Data Explorer
4 - Data Explorer

How to group rows by date so that groups are formed by day, without taking into account time. To get a group of October 4 with 2 rows and October 5 with 2 rows. I understand that the question is in the time display, but if you make a separate column with the formula DATETIME_FORMAT({Posting Time}, 'DD MM YY') and then group by it, then the program takes the date for text and sorts without taking into account the month, only by day.

1 Solution

Accepted Solutions

Hello,

You can add a formula to duplicate your field "Posting Time" and remove "include time" in the formating options of the formula:

Pascal_Gallais_0-1727970123864.pngPascal_Gallais_1-1727970148720.png

Regards,

Pascal

See Solution in Thread

2 Replies 2

Hello,

You can add a formula to duplicate your field "Posting Time" and remove "include time" in the formating options of the formula:

Pascal_Gallais_0-1727970123864.pngPascal_Gallais_1-1727970148720.png

Regards,

Pascal

Thank you very much, everything worked out