Filter By Year, Quarter

[jfoods300]

Hello, 

I have a production table with the production dates, is there a way or workaround I can create a filter like by quarter, by year?

[Suvrutt_Gurjar · Accepted solution]

You could have two VCs or real columns depending on how users update the date in your table, .one called [Production Year] with an expression TEXT([Production Date],"YYYY") for year and another one called [Production Quarters] with an expression such as 

IFS ( MONTH([Production Date]) <4, "Q1", 

       MONTH([Production Date]) <7, "Q2", 

       MONTH([Production Date]) <10, "Q3", 

       MONTH([Production Date]) >=10, "Q4",)

You could then use filter option in the search bar to filter by Production Year and/or  Production Quarter columns.

For filtering by quarter in a specific year, the dual filter of year and quarter columns can be used by the user.

Edit: You could also use these columns to group the records by Year and then quarter in the summary views such as table and deck view.

[jfoods300]

This works for me! THANK YOU!