I have rows with the same month and i want to create a dashboard to select month - but seeing multiple rows

[Tiger1]

I have a table:

I want to build a dashboard to allow my user to select by date. However, when i built the view to “Select a month” - it shows each row of the months (From the raw data). I want only one of the dates showing:

Here is how I set up the view:

[OptimiX_XcrY]

If I understand it right…

Add a virtual column to your table, with a formula that extracts the month from your [date] column.

Then sort and group your view by this [VirColMonth] , instead of by [date]

[Tiger1]

Ok. Thanks. Let me try this.