Page tree
Skip to end of metadata
Go to start of metadata

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


Grouped by month and count

d

Count

03 5
04 1
07 1
08 1
10 2
11 2
12 2
01 2
02 6
05 2
06 1
09 2
1


Grouped by month and summarized

d

Amount

03 20
04 2
07 4
08 3
10 654
11 458
12 0
01 696
02 4803
05 0
06 5
09 8
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>