How to GROUPBY Quarter for a Date Object


A customer may have a requirement to show dated data by quarter.



Step-by-step guide

  1. Take the following sample data which shows a date/time, an email address and is representative of customer orders.

  2. GROUPBY the year of the date, then apply the following formula using GROUPBYCUSTOMBIN


    The final column is a GROUPCOUNT which returns the total number of customer orders for that quarter.


You may also want to use visual panels to communicate related information, tips or things users need to be aware of.