How to group data by month (we use Virtual functions to format date as month)
d.formatDate(MM)
All values
d |
val |
---|---|
Mar 15, 2017 | 3 |
Mar 16, 2017 | 2 |
Apr 25, 2017 | 2 |
Jul 15, 2017 | 4 |
Aug 30, 2017 | 3 |
Oct 05, 2017 | |
Nov 09, 2017 | 2 |
Dec 13, 2017 | |
Jan 24, 2018 | 42 |
Feb 12, 2018 | 7 |
Feb 10, 2018 | 200 |
May 03, 2018 | |
May 06, 2018 | |
Jun 15, 2018 | 5 |
Sep 05, 2018 | 4 |
Sep 05, 2018 | 4 |
Nov 15, 2018 | 456 |
Dec 12, 2018 | |
Jan 17, 2019 | 654 |
Oct 23, 2015 | 654 |
Feb 07, 2019 | 4588 |
Feb 08, 2019 | |
Feb 17, 2019 | 5 |
Feb 21, 2019 | 3 |
Mar 12, 2019 | 9 |
Mar 12, 2019 | 5 |
Mar 15, 2017 | 1 |
Mar 24, 2019 | 3 |
Apr 27, 2019 | |
Apr 27, 2019 | 23 |
May 04, 2019 | |
Jun 12, 2019 | 2 |
Jun 12, 2019 | 6 |
Jun 25, 2019 | 7 |
Jul 02, 2019 | 9 |
Aug 07, 2019 | 324538 |
Mar 15, 2017 | 1000 |
Sep 19, 2019 | 1 |
Sep 20, 2019 | 222 |
Jan 31, 2020 | 42 |
Jan 31, 2020 | 9999999999 |
Jan 09, 2020 | 1 |
Feb 05, 2020 | 32 |
Mar 15, 2017 | 10 |
May 15, 2020 | 10 |
May 09, 2020 | |
Jun 19, 2020 | 4654254 |
Jun 17, 2020 | 12 |
Jun 11, 2020 | |
Jun 10, 2020 | 0 |
Jul 11, 2020 | |
Jul 31, 2020 | 100 |
Oct 07, 2020 | 12 |
Oct 07, 2020 | 24 |
Nov 20, 2020 | 15 |
Dec 30, 2020 | 4 |
Grouped by month and count
d |
Count |
---|---|
03 | 8 |
04 | 3 |
07 | 4 |
08 | 2 |
10 | 4 |
11 | 3 |
12 | 3 |
01 | 5 |
02 | 7 |
05 | 5 |
06 | 8 |
09 | 4 |
1 |
Grouped by month and summarized
d |
Amount |
---|---|
03 | 1033 |
04 | 25 |
07 | 113 |
08 | 324541 |
10 | 690 |
11 | 473 |
12 | 4 |
01 | 10000000738 |
02 | 4835 |
05 | 10 |
06 | 4654286 |
09 | 231 |
0 |
Storage format for the solution
<ac:structured-macro ac:macro-id="3b6beb46-cfe4-416b-9cde-93620daa42ad" ac:name="code" ac:schema-version="1"> <ac:plain-text-body><![CDATA[d.formatDate(MM)]]></ac:plain-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="cf299091-0b52-4ebf-ab28-6234d23853de" ac:name="confiform" ac:schema-version="1"> <ac:parameter ac:name="formName">f1</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="6adafd39-b987-4df2-abfa-8724e2e3e3c8" ac:name="confiform-entry-register" ac:schema-version="1"> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> <p> <ac:structured-macro ac:macro-id="207837ab-b088-447a-b257-c4492601b36d" ac:name="confiform-field-definition" ac:schema-version="1"> <ac:parameter ac:name="fieldName">d</ac:parameter> <ac:parameter ac:name="fieldLabel">d</ac:parameter> <ac:parameter ac:name="type">date</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="0f793df6-744e-40a5-a6de-e5db5b8270a5" ac:name="confiform-field-definition" ac:schema-version="1"> <ac:parameter ac:name="fieldName">val</ac:parameter> <ac:parameter ac:name="fieldLabel">val</ac:parameter> <ac:parameter ac:name="type">number</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <p>All values</p> <ac:structured-macro ac:macro-id="99ca4d1c-0c43-440f-9358-c094beac8832" ac:name="confiform-table" ac:schema-version="1"> <ac:parameter ac:name="formName">f1</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="923720bb-2a72-46a9-951c-f4a153893805" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">d</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="d372989c-b8b4-46c7-b044-bfb4d5d08ea9" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">val</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <p> </p> <p>Grouped by month and count</p> <ac:structured-macro ac:macro-id="51c8afe5-6ba8-4a7e-a558-b6d8e066a9a7" ac:name="confiform-table-merger" ac:schema-version="1"> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="68d44399-f531-4401-bab4-21347cdf036a" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">d.formatDate(MM)</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="f142e6f8-6f1f-4cba-99e1-e5701f89288f" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">Count:([count])</ac:parameter> </ac:structured-macro> </p> <ac:structured-macro ac:macro-id="dacd616a-909b-4e22-a6a4-a6b72210daa8" ac:name="confiform-table" ac:schema-version="1"> <ac:parameter ac:name="formName">f1</ac:parameter> <ac:rich-text-body> <p> </p> <p> </p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <p> </p> <p>Grouped by month and summarized</p> <ac:structured-macro ac:macro-id="f96aac1b-1089-4715-b7bc-af294fc919d3" ac:name="confiform-table-merger" ac:schema-version="1"> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="f9b8711d-8d90-4e1c-a6f8-668b73754010" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">d.formatDate(MM)</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id="4110edc0-e18e-4317-ae54-a3d1dd6c9945" ac:name="confiform-field" ac:schema-version="1"> <ac:parameter ac:name="fieldName">Amount:([entry.val])</ac:parameter> </ac:structured-macro> </p> <ac:structured-macro ac:macro-id="6bae1e39-ce09-4ff4-8cae-3e3d14c4518e" ac:name="confiform-table" ac:schema-version="1"> <ac:parameter ac:name="formName">f1</ac:parameter> <ac:rich-text-body> <p> </p> <p> </p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro>