Page tree

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

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
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
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
Sep 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


Grouped by month and count

d

Count

03 9
04 5
07 8
08 3
10 7
11 6
12 5
01 12
02 7
05 7
06 13
09 5
1


Grouped by month and summarized

d

Amount

03 1010102043
04 75
07 125
08 324542
10 334107
11 545
12 14
01 10000000744
02 4835
05 10
06 4654344
09 1031
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>