How to GROUPBY Quarter for a Date Object
A customer may have a requirement to show dated data by quarter.
- Take the following sample data which shows a date/time, an email address and is representative of customer orders.
- 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.|