I have a power table reading a column with a timestamp in it from an SQL database.
I have this column checked as filterable. However because the column is a timestamp when I hit filter i will for example get a list of hundreds of the same date in the dropdown box. this is because it is filtering by the month, day, and exact minute so every entry gets its own filterable option down to the minute.
Is there a way to only filter by day and ignore the hours and minutes in the column?