Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typeflat
separatorpipe
printablefalse

Overview

To complete the product manager dashboard, we'll make it so that the admin can filter the results based on UserDate and Status.

Image Added

 Image Removed

Source code

The following source code is shared using Confluence Storage Format, the XHTML-based format that Confluence uses to store the content of pages, page templates, blueprints, blog posts and comments.

For more information on how to use this source code on your Confluence, read the following article:


Expand
titleClick here for the source code ...


Code Block
<ac:structured-macro ac:macro-id="66ffc2d2-2b30-481a-b205-bbfa5cc3f886" ac:name="show-if" ac:schema-version="1">
  <ac:parameter ac:name="user">
    <ri:user ri:userkey="2c9180826b456b39016b456c262a0000"/>
  </ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="6116a97d-98da-4b9b-a599-3769114684bd" ac:name="deck" ac:schema-version="1">
      <ac:parameter ac:name="id">Admin View </ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="90d6f8bd-773e-48ef-897b-c96120d7c446" ac:name="card" ac:schema-version="1">
          <ac:parameter ac:name="label">Filter By User</ac:parameter>
          <ac:rich-text-body>
            <table class="wrapped relative-table" style="width: 26.3967%;">
              <colgroup> <col style="width: 19.5286%;"/> <col style="width: 80.1347%;"/> </colgroup>
              <tbody>
                <tr>
                  <th>Select User</th>
                  <td>
                    <div class="content-wrapper">
                      <ac:structured-macro ac:macro-id="c2c5d941-92eb-498a-a21b-d20514199b8b" ac:name="list-data" ac:schema-version="1">
                        <ac:parameter ac:name="name">userSearch</ac:parameter>
                        <ac:parameter ac:name="type">auto complete</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:rich-text-body>
                          <ac:structured-macro ac:macro-id="2822037c-00b5-4f3e-a0e5-ed2e5bf0ea6a" ac:name="user-options" ac:schema-version="1">
                            <ac:rich-text-body>
                              <p>
                                <br/>
                              </p>
                            </ac:rich-text-body>
                          </ac:structured-macro>
                        </ac:rich-text-body>
                      </ac:structured-macro>
                    </div>
                  </td>
                </tr>
              </tbody>
            </table>
            <ac:structured-macro ac:macro-id="38d5eb12-68b2-4ab9-adba-e318f017cadb" ac:name="report-table" ac:schema-version="1">
              <ac:parameter ac:name="injected">true</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="cdf98a74-8378-4150-8723-ebacae1f3445" ac:name="expanding-reporter" ac:schema-version="1">
                  <ac:parameter ac:name="as">Task</ac:parameter>
                  <ac:parameter ac:name="">data:Task</ac:parameter>
                  <ac:rich-text-body>
                    <ac:structured-macro ac:macro-id="40c9aada-a259-4751-903d-8e02c1a875c9" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="">page:children</ac:parameter>
                      <ac:rich-text-body>
                        <p>
                          <br/>
                        </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <p>
                      <ac:structured-macro ac:macro-id="36cf05ae-9455-4f72-a42b-de0f17e215e3" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="value">%data:userSearch>1%</ac:parameter>
                        <ac:parameter ac:name="">data:User</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="c4aa2d45-bc41-4bdf-9464-a59f5e2ce672" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="injected">true</ac:parameter>
                  <ac:parameter ac:name="title">Assignee</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="b8c14c79-53e0-4525-8a91-f2b6989404ed" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:User</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="6d8d1d54-748f-4e0f-b556-979d99a15ba9" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Description</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="7d3e4e03-c535-4369-8fe8-9f4311318888" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Description</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="b6209faf-9884-43c0-b8e6-befcda7d1dc8" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Due Date</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="97bd7c3a-800c-4bd8-9c19-407e2687fd63" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="6fabb5cc-ddd3-4a07-8eee-704d5946065a" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Status</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="90b3c925-27ad-4bf0-8ebb-9adc07b68de6" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:Status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="c9d1a5b4-768a-446b-9af6-4676a5fbbf52" ac:name="report-footer" ac:schema-version="1">
                  <ac:rich-text-body>
                    <table class="wrapped relative-table" style="width: 20.6701%;">
                      <colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
                      <tbody>
                        <tr>
                          <td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
                            <p title="">Total Number of Tasks: </p>
                            <div class="content-wrapper" title="">
                              <p>
                                <ac:structured-macro ac:macro-id="4ca0475c-c031-462a-a1ab-a5423757c1c1" ac:name="report-info" ac:schema-version="1">
                                  <ac:parameter ac:name="">report:query>size</ac:parameter>
                                </ac:structured-macro>
                              </p>
                            </div>
                          </td>
                        </tr>
                      </tbody>
                    </table>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p>
              <br/>
            </p>
            <p>
              <br/>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="932745d7-2098-41a5-b069-16e3f7846f09" ac:name="card" ac:schema-version="1">
          <ac:parameter ac:name="label">Filter By Due Date</ac:parameter>
          <ac:rich-text-body>
            <table class="wrapped relative-table" style="width: 28.5255%;">
              <colgroup> <col style="width: 18.2762%;"/> <col style="width: 81.4123%;"/> </colgroup>
              <tbody>
                <tr>
                  <th>Select Date</th>
                  <td>
                    <div class="content-wrapper">
                      <ac:structured-macro ac:macro-id="7ff4828b-b855-41d4-bdfb-b83344a842c7" ac:name="date-data" ac:schema-version="1">
                        <ac:parameter ac:name="format">dd-MMM-yyyy</ac:parameter>
                        <ac:parameter ac:name="name">dateSearch</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                      </ac:structured-macro>
                    </div>
                  </td>
                </tr>
              </tbody>
            </table>
            <ac:structured-macro ac:macro-id="9d6dc1af-3c46-4cc7-91fd-3cf07cbee480" ac:name="report-table" ac:schema-version="1">
              <ac:parameter ac:name="injected">true</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="e25a034f-400a-4326-877b-30a526c94b9b" ac:name="expanding-reporter" ac:schema-version="1">
                  <ac:parameter ac:name="as">Task</ac:parameter>
                  <ac:parameter ac:name="">data:Task</ac:parameter>
                  <ac:rich-text-body>
                    <ac:structured-macro ac:macro-id="e59b95f0-492a-4d6a-a3b7-ebbdac3bd0ca" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="">page:children</ac:parameter>
                      <ac:rich-text-body>
                        <p>
                          <br/>
                        </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <p>
                      <ac:structured-macro ac:macro-id="232bf2d1-2dc3-4f12-9ead-c77c67b93198" ac:name="number-filter" ac:schema-version="1">
                        <ac:parameter ac:name="aboveValue">%data:dateSearch>milliseconds%</ac:parameter>
                        <ac:parameter ac:name="">data:Due Date>milliseconds</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="b1ceaa1b-c8f2-44e9-a7a6-7b729e35de74" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="injected">true</ac:parameter>
                  <ac:parameter ac:name="title">Assignee</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="f8525054-5998-4377-acd1-bdd512776a3d" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:User</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="cd901fc3-200e-44b0-b93c-4a97e2acb564" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Description</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="ec152cf0-e456-46f4-9f92-5927571104be" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Description</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="6d6842de-22d9-40ba-ac84-f99d83c51d5b" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Due Date</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="74d0445f-1dad-4603-aea9-69c9d89c9a82" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="8be7b5f3-d115-4ed3-91ff-d36a9b7bb752" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Status</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="dbd2ea20-c19f-497b-94ef-ec64944198bc" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:Status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="7bea169e-288f-44a3-81be-0f07e069ff90" ac:name="report-footer" ac:schema-version="1">
                  <ac:rich-text-body>
                    <table class="wrapped relative-table" style="width: 20.6701%;">
                      <colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
                      <tbody>
                        <tr>
                          <td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
                            <p title="">Total Number of Tasks: </p>
                            <div class="content-wrapper" title="">
                              <p>
                                <ac:structured-macro ac:macro-id="b37aa8bf-5719-4fd8-b07a-cb9b6a38e987" ac:name="report-info" ac:schema-version="1">
                                  <ac:parameter ac:name="">report:query>size</ac:parameter>
                                </ac:structured-macro>
                              </p>
                            </div>
                          </td>
                        </tr>
                      </tbody>
                    </table>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <p>
              <br/>
            </p>
            <p>
              <br/>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="5fe41a7c-bc08-4b76-bc81-67b6bf7d9567" ac:name="card" ac:schema-version="1">
          <ac:parameter ac:name="label">Filter By Status</ac:parameter>
          <ac:rich-text-body>
            <table class="wrapped relative-table" style="width: 25.971%;">
              <colgroup> <col style="width: 22.5873%;"/> <col style="width: 77.3443%;"/> </colgroup>
              <tbody>
                <tr>
                  <th>Select Status</th>
                  <td>
                    <div class="content-wrapper">
                      <ac:structured-macro ac:macro-id="6956bcb8-9967-4e44-906c-59c042f87974" ac:name="list-data" ac:schema-version="1">
                        <ac:parameter ac:name="name">statusSearch</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:rich-text-body>
                          <ac:structured-macro ac:macro-id="f1956060-e6bd-4959-993f-c3122deae231" ac:name="list-option" ac:schema-version="1">
                            <ac:parameter ac:name="value">Open</ac:parameter>
                            <ac:rich-text-body>
                              <p>
                                <br/>
                              </p>
                            </ac:rich-text-body>
                          </ac:structured-macro>
                          <ac:structured-macro ac:macro-id="f9d8f4e1-d373-4bd7-94d9-07aeb90a939f" ac:name="list-option" ac:schema-version="1">
                            <ac:parameter ac:name="value">In Progress</ac:parameter>
                            <ac:rich-text-body>
                              <p>
                                <br/>
                              </p>
                            </ac:rich-text-body>
                          </ac:structured-macro>
                          <ac:structured-macro ac:macro-id="3347e340-dd00-4b6a-969d-a8261c73d384" ac:name="list-option" ac:schema-version="1">
                            <ac:parameter ac:name="value">Done</ac:parameter>
                            <ac:rich-text-body>
                              <p>
                                <br/>
                              </p>
                            </ac:rich-text-body>
                          </ac:structured-macro>
                        </ac:rich-text-body>
                      </ac:structured-macro>
                    </div>
                  </td>
                </tr>
              </tbody>
            </table>
            <ac:structured-macro ac:macro-id="7302f6ce-b193-4091-9349-ebbcc1391100" ac:name="report-table" ac:schema-version="1">
              <ac:parameter ac:name="injected">true</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="9c746784-f82c-41c9-9c40-ca77abda98a2" ac:name="expanding-reporter" ac:schema-version="1">
                  <ac:parameter ac:name="as">Task</ac:parameter>
                  <ac:parameter ac:name="">data:Task</ac:parameter>
                  <ac:rich-text-body>
                    <ac:structured-macro ac:macro-id="84fbdea6-927f-45a5-a16d-ea1a15599980" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="">page:children</ac:parameter>
                      <ac:rich-text-body>
                        <p>
                          <br/>
                        </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <p>
                      <ac:structured-macro ac:macro-id="8928baab-faa0-48d1-91dc-107f11376696" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="value">%data:statusSearch>1%</ac:parameter>
                        <ac:parameter ac:name="">data:Status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="218c8e0a-a4a1-433a-aa9f-5eb3e32ef7b4" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="injected">true</ac:parameter>
                  <ac:parameter ac:name="title">Assignee</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="8720d5ed-58df-489b-9926-06c0c6e15cc6" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:User</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="6c5b0d65-2592-4f49-8c1b-96e80b9c6c70" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Description</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="3b19141c-3b2a-4984-a453-a698644f6869" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Description</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="e978cea1-0517-4e8d-b855-7ccfa33b8a60" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Due Date</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="e05cb75c-7591-486b-b54a-d8f7e794975a" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
                        <ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="6066009f-2a29-4136-a946-c5fb66db4460" ac:name="report-column" ac:schema-version="1">
                  <ac:parameter ac:name="title">Status</ac:parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="e80d0543-d234-46f9-a693-7ba7072a8664" ac:name="report-info" ac:schema-version="1">
                        <ac:parameter ac:name="">Task>data:Status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:macro-id="7359abff-9584-4cbf-be6a-45c698b90497" ac:name="report-footer" ac:schema-version="1">
                  <ac:rich-text-body>
                    <table class="wrapped relative-table" style="width: 20.6701%;">
                      <colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
                      <tbody>
                        <tr>
                          <td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
                            <p title="">Total Number of Tasks: </p>
                            <div class="content-wrapper" title="">
                              <p>
                                <ac:structured-macro ac:macro-id="6383b625-e2cc-4e3a-8621-5217fa075ace" ac:name="report-info" ac:schema-version="1">
                                  <ac:parameter ac:name="">report:query>size</ac:parameter>
                                </ac:structured-macro>
                              </p>
                            </div>
                          </td>
                        </tr>
                      </tbody>
                    </table>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>



Steps

  1. Add three level 3 headings "Filter By User", "Filter By Due Date", and "Filter

...

  1. By Status".

  2. Under the "Filter By User",do as follows:

    1. Add a 2x1 table, enter "Select User" in the first column and add a List Data macro in the second column.
      Set its name to "userSearch" and set its type to "auto complete"

    2. Add a User Options macro within the List Data macro.

    3. Create a Report Table  macro and within it create an Expanding Reporter and set its Key and As parameters to "data:Task" and "Task" respectively.

    4. Within the Expanding Reporter macro, create a Local Reporter macro and set the Key parameter to "page:children".

    5. Within the Expanding Reporter macro, add a Text Filter macro. Set the Key and Exact Value to "data:User" and "%data:userSearch>1%" respectively.

    6. Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.

    7. In the "Assignee" Report column, add a Report Info macro and set its Key parameter to "Task>data:User".

    8. In the "Description" Report column, add a Report Info macro and set its Key parameter to "Task>data:Description".

    9. In the "Due Date" Report column, add a Report Info macro and set its Key parameter to "Task>data:Due Date".

    10. In the "Status" Report column, add a Report Info macro and set its Key parameter to "Task>data:Status".

    11. Add a Report Footer macro.

    12. Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example.)

    13. Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "Report:query>size".

  3. Under the "Filter

...

  1. by Due Date", do as follows: 

    1. Add a 2x1 table, write "Select Date" in the first column.
      Add a Date Data macro.
      Set its name to "dateSearch" in the second column.

    2. Create a Report Table macro.

    3. Within the Report Table macro, create an Expanding Reporter macro.
      Set its Key and As parameters to "data:Task"  and "Task" respectively.

    4. Within the Expanding Reporter macro, create a Local Reporter macro and set its Key parameter to "page:children".

    5. Within the Expanding Reporter macro, add a Number Filter macro.
      Set its Key and Above Value parameters to "data:Due Date>milliseconds" and "%data:dateSearch>milliseconds%" respectively

    6. Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.

    7. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User".

    8. In the "Description" Report Column macro, add a Report

...

    1. Info macro and set its Key parameter to "Task>data:Description".

    2. In the "Due DateReport Column macro, add a Report Info macro and set its Key parameter to "Task>data:Due Date".

    3. In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Status".

    4. Add a Report Footer macro.

    5. Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example).
      Write  "Total Number of Tasks:"  and Add a Report Info macro and set its Key parameter to "Report:query>size".

  1. Under the "Filter

...

  1. By Status, do as follows:

    1. Add a 2x1 Table, write "Select Status" in the first column and add a List Data macro.
      Set its name to "statusSearch" in the second column.

    2. Within the List Data macro, add 3 List Option macros.
      Set their Value parameters to "Open", "In Progress", and "Done" respectively.

    3. Create a Report Table macro.

    4. Within the Report Table macro, create an Expanding Reporter macro.
      Set its Key and As parameters to "data:Task" and "Task" respectively.

    5. Within the Expanding Reporter macro, create a Local Reporter macro.
      Set its Key parameter to "page:children".

    6. Add a Text Filter macro within the Expanding Reporter macro.
      Set its Key and Exact Value to "data:Status" and "%data:statusSearch>1%" respectively.

    7. Within the Report Table macro, add four Report Column macros.
      Set their title to "Assignee", "Description", "Due Date" and "Status" respectively.

    8. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User".

    9. In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Description".

    10. In the "Due DateReport Column macro, add a Report Info macro and set its Key parameter to "Task>data:Due Date".

    11. In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Status".

    12. Add a Report Footer macro.

    13. Add a 1x1 table in the Report Footer macro.
      Color it as desired. (Orange is used in this example.)

    14. Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "Report:query>size".

Macro structure

...

Auibutton
iconapprove
titleYOU'RE DONE!
typestandard
urlCreating a project overview dashboard and progress checklist (with Reporting and Scaffolding only)