Forum Discussion
groups and binning
Hello, I have list of month year in a table. (Jan 2018, Feb 2018, Mar 2018, Apr 2018, May 2018, June 2018, Jul 2018, Aug 2018, Sept 2018, Oct 2018, etc), I want to group it every 2 months, so, F...
HI!,
I tried to use your first solution, because turns out the column is in date form, but it's not what I want to do.
so what happen is Jan and Feb = Feb
March and April = March
With this, I only have 6 data groups in a year, it's supposed to be 12.
but what I wanted is
Dec and Jan = Jan
Jan and Feb = Feb,
Feb and March = March
March and April = April.
I created a table consists of 2 columns Grouping and Period.
Content of the data will be
- Grouping - Period
- Jan 2018 - Dec 2017
- Jan 2018 - Jan 2018
- Feb 2018 - Jan 2018
- Feb 2018 - Feb 2018
- Mar 2018 - Feb 2018
- Mar 2018 - Mar 2018
- and so on...
Then match the period column with the same in other table, and group the chart based on Grouping column.
It's a bit hardcoded, but it works for now...if anybody have a simpler way/more dynamic way to do this, I would appreciate.
Thanks & Rgds,
Lina