How to group by rows in the filter view?

Ask for Help
1

Hi ,
I have activated a date column in App filter.
In the filter panel, for the same day, several rows are displayed.
Is it possible to discard the duplicated rows ?

Date Column is

  • type : Date & Time
  • Parts : Date only
  • Date format : short

image

2

Use Date format column since the actual date column also includes the time that’s why several rows are displayed.

Step 1:

Date Filter 1
Date Filter 11192Ă—701 68.6 KB

Step 2:

Date Filter 2
Date Filter 21187Ă—842 82.2 KB

We have to get rid of time when using the Date Format column to apply the filter because time is not unique in each row.

3

I think you can just have a template column pointing to your date column to “lock” the format in, then use that in your filter.

4

I always prefer Format Date column so I can format the date accordingly but yes I think template can also work.

5

Always test that column extensively on all OS, especially iOS, since it has proven to be a problem in the past.

6

What he said :point_down:

Use that column at your own risk. It might work 99.99% of the time, but that one time it breaks it will take you days to figure out whats going wrong.

7

I have used that over 100 of my apps. Didn’t know there was a risk.

8