I need help figuring out how create a dynamic quarterly chart for a dashboard. For example I have a call log report in a board I’d like to create various widgets for the last 30,60,90 days. It looks like it may be a more complicated or advanced filter. Thoughts?
Hi @Chae
I’m assuming you have a Date column for each call on the board.
This is what I suggest:
Create a Formula column and use this formula:
“Q” & FORMAT_DATE({Date}, “Q-YYYY”)
*Make sure the write the name of the Date column correctly inside the { }
Then you will get something like that:
Next step, you can filter your dashboard according to the Quarter column
If you need any help you can contact me,
Hezi