How to GROUPBY Quarter for a Date Object

Goal

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

 

Learn

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.