Playground and DEMO space
This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC
Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action
To import examples from the storage format on Confluence Cloud please see this page
Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.
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 |
| Sept 05, 2018 | 4 |
| Sept 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 |
| Sept 19, 2019 | 1 |
| Sept 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 |
| Jan 20, 2021 | 1 |
| Jan 27, 2021 | 2 |
| Jan 28, 2021 | |
| Jan 13, 2021 | 0 |
| Jan 31, 2021 | 1 |
| Jan 31, 2020 | 1 |
| Jan 31, 2021 | 1 |
| Dec 16, 2021 | 10 |
| May 17, 2021 | |
| Jun 05, 2021 | 3 |
| Mar 04, 2021 | 1010101010 |
| Jul 02, 2021 | |
| Jul 15, 2021 | 5 |
| Jul 31, 2021 | 6 |
| Aug 20, 2021 | 1 |
| Sept 01, 2021 | 800 |
| Nov 11, 2021 | 22 |
| Nov 16, 2021 | 45 |
| Oct 28, 1993 | 28 |
| Apr 23, 2022 | |
| May 18, 2022 | |
| Jun 16, 2022 | 10 |
| Apr 21, 2022 | 50 |
| Jun 01, 2022 | 22 |
| Jun 02, 2022 | 23 |
| Jun 14, 2022 | |
| Jul 28, 2022 | 1 |
| Oct 12, 2022 | 56 |
| Oct 06, 2022 | 333333 |
| Nov 18, 2022 | 5 |
| Dec 07, 2022 | |
| Jan 20, 2023 | 45 |
| Feb 17, 2023 | 7 |
| Mar 24, 2023 | |
| Mar 15, 2023 | |
| Mar 30, 2023 | 100000 |
| Apr 05, 2023 | |
| Apr 21, 2023 | 123 |
| Apr 19, 2023 | 3213 |
| May 31, 2023 | 2 |
| Jun 04, 2023 | 5 |
| Jul 20, 2023 | 2 |
| Feb 12, 2018 | 8 |
| Nov 02, 2023 | |
| Nov 14, 2023 | |
| Jan 18, 2024 | |
| Jan 12, 2024 | 10,7 |
| Jan 13, 2024 | |
| Jan 13, 2024 | 2 |
| Jan 13, 2024 | |
| Apr 11, 2024 | 232323 |
| 1 |
Grouped by month and count
|
d |
Count |
|---|---|
| 03 | 12 |
| 04 | 9 |
| 07 | 9 |
| 08 | 3 |
| 10 | 7 |
| 11 | 8 |
| 12 | 5 |
| 01 | 18 |
| 02 | 9 |
| 05 | 8 |
| 06 | 14 |
| 09 | 5 |
| 2 |
Configuration
Grouped by month and summarized
|
d |
Amount |
|---|---|
| 03 | 1010202043 |
| 04 | 235734 |
| 07 | 127 |
| 08 | 324542 |
| 10 | 334107 |
| 11 | 545 |
| 12 | 14 |
| 01 | 10000000801.7 |
| 02 | 4850 |
| 05 | 12 |
| 06 | 4654349 |
| 09 | 1031 |
| 1 |
Configuration
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>