Show distinct values in a filter

[aguirre]

I have a table with a date column.

I want a filter to show distinct value and not:

What should I do?

[Qrishna · Accepted solution]

i think even though you are just seing the date, i believe theres a different timestamp stuck to each date value hence the filter is taking each date as different field value.

try modifying your date field something like below:

Date(Floor(Timestamp#(DATE_CREATED,'DD-MMM-YY hh.mm.ss.fffffffff')),'DD/MM/YYYY') as DateField

you could just create new filter panne with this function instead of modifying it in the data load editor.

let me know once you do it.

[aguirre]

Yes @Qrishna you were right and I did as you wrote. THanks