Hi Everyone,
I’m setting up a pivot in the Dashboards section, and I noticed that under the Date part functions we currently have options like PartYear, PartMonth, PartWeek, PartDay, etc., but there’s no option to get the quarter of a date.
My use case is quite common: I’d like to group or report records by the quarter of the Created on date (e.g. Q1–Q4), similar to how months or weeks can be derived.
Is there a recommended workaround for this today (for example using formulas or logic), or is there a plan to introduce something like a PartQuarter function in future releases?
Any tips, best practices, or ideas would be much appreciated. Thanks in advance!
Like
Hello,
Unfortunately, it is not currently possible to add a quarter as one of the options in the Date part in the chart setup.
However, we have created a request for our R&D team to extend this functionality in future releases of the system.
Thank you for your question!