Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Grouped by 1 field

Solved
Jump to Solution
632 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