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?
Solved! Go to 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.
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.
This works for me! THANK YOU!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |