I need help on totaling numbers in a grouped column.

  • 1
  • Question
  • Updated 2 years ago

I am using the grouped macro to summarize items in a report table. I can't figure out how to total the entries in each column. My source editor is below:


<ac:macro ac:name="show-if">
  <ac:parameter ac:name="action">edit</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
  <ac:rich-text-body>
    <ac:macro ac:name="table-plus">
      <ac:parameter ac:name="sortColumn">5</ac:parameter>
      <ac:parameter ac:name="enableSorting">true</ac:parameter>
      <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
      <ac:rich-text-body>
        <ac:macro ac:name="table-data">
          <ac:parameter ac:name="initialRows">1</ac:parameter>
          <ac:parameter ac:name="name">ProductProfiles2016</ac:parameter>
          <ac:rich-text-body>
            <table>
              <tbody>
                <tr>
                  <th colspan="1">
                    <h4>Writer</h4>
                  </th>
                  <th>
                    <h4>Product</h4>
                  </th>
                  <th colspan="1">
                    <h4>Task</h4>
                  </th>
                  <th colspan="1">
                    <h4>Start</h4>
                  </th>
                  <th colspan="1">
                    <h4>End</h4>
                  </th>
                  <th>
                    <h4>Status</h4>
                  </th>
                  <th>
                    <h4>Comments</h4>
                  </th>
                </tr>
                <tr>
                  <td colspan="1">
                    <p>
                      <ac:macro ac:name="list-data">
                        <ac:parameter ac:name="width">10em</ac:parameter>
                        <ac:parameter ac:name="name">Writer</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:parameter ac:name="separator">newline</ac:parameter>
                        <ac:rich-text-body>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value"/>
                            <ac:rich-text-body> </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Brewer</ac:parameter>
                            <ac:parameter ac:name="sortValue">1</ac:parameter>
                            <ac:rich-text-body>
                              <p>Brewer</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Lindquist</ac:parameter>
                            <ac:parameter ac:name="sortValue">2</ac:parameter>
                            <ac:rich-text-body>
                              <p>Lindquist</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Powell</ac:parameter>
                            <ac:parameter ac:name="sortValue">3</ac:parameter>
                            <ac:rich-text-body>
                              <p>Powell</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Robinson</ac:parameter>
                            <ac:parameter ac:name="sortValue">4</ac:parameter>
                            <ac:rich-text-body>
                              <p>Robinson</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Shin</ac:parameter>
                            <ac:parameter ac:name="sortValue">5</ac:parameter>
                            <ac:rich-text-body>
                              <p>Shin</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Summerlin</ac:parameter>
                            <ac:parameter ac:name="sortValue">6</ac:parameter>
                            <ac:rich-text-body>
                              <p>Summerlin</p>
                            </ac:rich-text-body>
                          </ac:macro>
                        </ac:rich-text-body>
                      </ac:macro>
                    </p>
                  </td>
                  <td>
                    <p>
                      <ac:macro ac:name="text-data">
                        <ac:parameter ac:name="height">5em</ac:parameter>
                        <ac:parameter ac:name="width">15em</ac:parameter>
                        <ac:parameter ac:name="name">Product</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:parameter ac:name="type">line</ac:parameter>
                        <ac:rich-text-body> </ac:rich-text-body>
                      </ac:macro> </p>
                    <p> </p>
                    <p> </p>
                    <p> </p>
                  </td>
                  <td colspan="1">
                    <p>
                      <ac:macro ac:name="list-data">
                        <ac:parameter ac:name="width">10em</ac:parameter>
                        <ac:parameter ac:name="name">task</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:parameter ac:name="separator">newline</ac:parameter>
                        <ac:rich-text-body>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value"/>
                            <ac:rich-text-body> </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Refresh</ac:parameter>
                            <ac:parameter ac:name="sortValue">1</ac:parameter>
                            <ac:rich-text-body>
                              <p>Refresh</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">New</ac:parameter>
                            <ac:parameter ac:name="sortValue">2</ac:parameter>
                            <ac:rich-text-body>
                              <p>New</p>
                            </ac:rich-text-body>
                          </ac:macro>
                        </ac:rich-text-body>
                      </ac:macro>
                    </p>
                  </td>
                  <td colspan="1">
                    <p>
                      <ac:macro ac:name="date-data">
                        <ac:parameter ac:name="maxDate">01-01-2017</ac:parameter>
                        <ac:parameter ac:name="name">Start</ac:parameter>
                        <ac:parameter ac:name="minDate">01-01-2015</ac:parameter>
                        <ac:parameter ac:name="format">MM-dd-yyyy</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:plain-text-body><![CDATA[ ]]></ac:plain-text-body>
                      </ac:macro>
                    </p>
                  </td>
                  <td colspan="1">
                    <p>
                      <ac:macro ac:name="date-data">
                        <ac:parameter ac:name="maxDate">01-01-2017</ac:parameter>
                        <ac:parameter ac:name="name">End</ac:parameter>
                        <ac:parameter ac:name="minDate">12-01-2015</ac:parameter>
                        <ac:parameter ac:name="format">MM-dd-yyyy</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:plain-text-body><![CDATA[ ]]></ac:plain-text-body>
                      </ac:macro>
                    </p>
                  </td>
                  <td>
                    <p>
                      <ac:macro ac:name="list-data">
                        <ac:parameter ac:name="width">10em</ac:parameter>
                        <ac:parameter ac:name="name">Status</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:parameter ac:name="separator">newline</ac:parameter>
                        <ac:rich-text-body>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value"/>
                            <ac:rich-text-body> </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">In progress</ac:parameter>
                            <ac:parameter ac:name="sortValue">1</ac:parameter>
                            <ac:rich-text-body>
                              <p>In progress</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Complete</ac:parameter>
                            <ac:parameter ac:name="sortValue">2</ac:parameter>
                            <ac:rich-text-body>
                              <p>Completed</p>
                            </ac:rich-text-body>
                          </ac:macro>
                          <ac:macro ac:name="list-option">
                            <ac:parameter ac:name="value">Cancelled</ac:parameter>
                            <ac:parameter ac:name="sortValue">3</ac:parameter>
                            <ac:rich-text-body>
                              <p>Cancelled</p>
                            </ac:rich-text-body>
                          </ac:macro>
                        </ac:rich-text-body>
                      </ac:macro>
                    </p>
                  </td>
                  <td>
                    <p>
                      <ac:macro ac:name="text-data">
                        <ac:parameter ac:name="height">5em</ac:parameter>
                        <ac:parameter ac:name="width">15em</ac:parameter>
                        <ac:parameter ac:name="name">Comments</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:rich-text-body> </ac:rich-text-body>
                      </ac:macro> </p>
                    <p> </p>
                    <p> </p>
                  </td>
                </tr>
              </tbody>
            </table>
          </ac:rich-text-body>
        </ac:macro>
      </ac:rich-text-body>
    </ac:macro>
  </ac:rich-text-body>
</ac:macro>
<ac:macro ac:name="show-if">
  <ac:parameter ac:name="action">view</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
  <ac:rich-text-body>
    <ac:macro ac:name="report-table">
      <ac:rich-text-body>
        <ac:macro ac:name="local-reporter">
          <ac:default-parameter>data:ProductProfiles2016</ac:default-parameter>
          <ac:rich-text-body>
            <p> </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Writer</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:default-parameter>data:Writer</ac:default-parameter>
              </ac:macro>
            </p>
            <p> </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Product</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:parameter ac:name="render">richtext</ac:parameter>
                <ac:default-parameter>data:Product</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Task</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:default-parameter>data:task</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Start Date</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:parameter ac:name="format">MM-dd-yy</ac:parameter>
                <ac:default-parameter>data:Start</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">End Date</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:parameter ac:name="format">MM-dd-yy</ac:parameter>
                <ac:default-parameter>data:End</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Status</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:default-parameter>data:Status</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Comments</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:parameter ac:name="format">MM-dd-yy</ac:parameter>
                <ac:parameter ac:name="render">richtext</ac:parameter>
                <ac:default-parameter>data:Comments</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
      </ac:rich-text-body>
    </ac:macro>
    <p> </p>
    <p> </p>
  </ac:rich-text-body>
</ac:macro>
<p> </p>
<p> </p>
<hr/>
<hr/>
<h3>
  <span style="color: rgb(255,102,0);">2016 Product Profile Totals</span>
</h3>
<p> </p>
<ac:macro ac:name="report-table">
  <ac:rich-text-body>
    <ac:macro ac:name="grouping-reporter">
      <ac:parameter ac:name="as">writer</ac:parameter>
      <ac:default-parameter>data:Writer</ac:default-parameter>
      <ac:rich-text-body>
        <ac:macro ac:name="local-reporter">
          <ac:default-parameter>data:ProductProfiles2016</ac:default-parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="text-sort">
                <ac:default-parameter>data:Writer</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <p> </p>
        <p>
          <ac:macro ac:name="grouping-stats">
            <ac:parameter ac:name="as">Task</ac:parameter>
            <ac:default-parameter>data:task</ac:default-parameter>
          </ac:macro>
        </p>
        <p>
          <ac:macro ac:name="grouping-stats">
            <ac:parameter ac:name="as">Status</ac:parameter>
            <ac:default-parameter>data:Status</ac:default-parameter>
          </ac:macro>
        </p>
      </ac:rich-text-body>
    </ac:macro>
    <ac:macro ac:name="report-column">
      <ac:parameter ac:name="title">Writer</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:macro ac:name="report-info">
            <ac:parameter ac:name="render">wiki</ac:parameter>
            <ac:default-parameter>grouped:writer</ac:default-parameter>
          </ac:macro>
        </p>
      </ac:rich-text-body>
    </ac:macro>
    <ac:macro ac:name="report-column">
      <ac:parameter ac:name="title">Refresh in Progress</ac:parameter>
      <ac:parameter ac:name="injected">true</ac:parameter>
      <ac:parameter ac:name="summaryValue">%grouped:@items%</ac:parameter>
      <ac:parameter ac:name="summaryType">sum</ac:parameter>
      <ac:rich-text-body>
        <ac:macro ac:name="report-block">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="local-reporter">
              <ac:default-parameter>grouped:@items</ac:default-parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="and-filter">
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="include">.*Refresh.*</ac:parameter>
                        <ac:default-parameter>data:task</ac:default-parameter>
                      </ac:macro>
                    </p>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="include">.*progress.*</ac:parameter>
                        <ac:default-parameter>data:Status</ac:default-parameter>
                      </ac:macro>
                    </p>
                  </ac:rich-text-body>
                </ac:macro>
                <p> </p>
                <p>
                  <ac:macro ac:name="text-sort">
                    <ac:default-parameter>data:Writer</ac:default-parameter>
                  </ac:macro>
                </p>
                <p> </p>
              </ac:rich-text-body>
            </ac:macro>
            <ac:macro ac:name="report-header">
              <ac:rich-text-body>
                <p>
                  <ac:macro ac:name="report-info">
                    <ac:parameter ac:name="render">richtext</ac:parameter>
                    <ac:default-parameter>report:query&gt;size</ac:default-parameter>
                  </ac:macro>
                </p>
              </ac:rich-text-body>
            </ac:macro>
            <ac:macro ac:name="report-body">
              <ac:rich-text-body>
                <p> </p>
              </ac:rich-text-body>
            </ac:macro>
            <p> </p>
            <p> </p>
          </ac:rich-text-body>
        </ac:macro>
      </ac:rich-text-body>
    </ac:macro>
    <ac:macro ac:name="report-column">
      <ac:parameter ac:name="title">Refresh Complete</ac:parameter>
      <ac:rich-text-body>
        <ac:macro ac:name="report-block">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="local-reporter">
              <ac:default-parameter>grouped:@items</ac:default-parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="and-filter">
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="include">.*Refresh.*</ac:parameter>
                        <ac:default-parameter>data:task</ac:default-parameter>
                      </ac:macro>
                    </p>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="include">.*Complete.*</ac:parameter>
                        <ac:default-parameter>data:Status</ac:default-parameter>
                      </ac:macro>
                    </p>
                  </ac:rich-text-body>
                </ac:macro>
              </ac:rich-text-body>
            </ac:macro>
            <ac:macro ac:name="report-header">
              <ac:rich-text-body>
                <p>
                  <ac:macro ac:name="report-info">
                    <ac:default-parameter>report:query&gt;size</ac:default-parameter>
                  </ac:macro>
                </p>
              </ac:rich-text-body>
            </ac:macro>
            <ac:macro ac:name="report-body">
              <ac:rich-text-body>
                <p> </p>
              </ac:rich-text-body>
            </ac:macro>
          </ac:rich-text-body>
        </ac:macro>
        <p> </p>
        <br/>
        <p> </p>
      </ac:rich-text-body>
    </ac:macro>
    <ac:macro ac:name="report-column">
      <ac:parameter ac:name="title">New in Progress</ac:parameter>
      <ac:rich-text-body>
        <ac:macro ac:name="report-block">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="local-reporter">
              <ac:default-parameter>grouped:@items</ac:default-parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="and-filter">
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter"

Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
  • like I need a little help.

Posted 2 years ago

  • 1

There are no replies.