Reporting counting number of occurances

Steve Boydon_fchh1g

Hi


I never really got on with pivot tables and charts in Excel and it seems to have carried over to Confluence

I need to create some pretty basic reports.

I have the following

<ac:structured-macro ac:name="report-table">  <ac:parameter ac:name="injected">true</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:name="grouping-reporter">
      <ac:parameter ac:name="as">Compliance Status</ac:parameter>
      <ac:parameter ac:name="">data:evidence-compliance-status</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:name="local-reporter">
          <ac:parameter ac:name="source">Control Evidence</ac:parameter>
          <ac:parameter ac:name="">page:children</ac:parameter>
          <ac:rich-text-body>
            <p> </p>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:name="report-column">
      <ac:parameter ac:name="title">Compliance Status</ac:parameter>
      <ac:parameter ac:name="width">120px</ac:parameter>
      <ac:rich-text-body>
        <p>%grouped:Compliance Status%</p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:name="report-column">
      <ac:parameter ac:name="title">Number</ac:parameter>
      <ac:rich-text-body>
        <p>%Compliance Status &gt; count%</p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:name="report-empty">
      <ac:rich-text-body>
        <ac:structured-macro ac:name="column">
          <ac:parameter ac:name="width">270px</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:name="hinchpanel">
              <ac:parameter ac:name="color">red</ac:parameter>
              <ac:parameter ac:name="width">90</ac:parameter>
              <ac:rich-text-body>
                <p>No Evidence yet</p>
              </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>


Basically a report table that does a lookup across a bunch of pages and counts the number of compliance statuses for each value.

So i get a table with 2 columns the first one gives me each instance of compliance status. What i now need to do is count how many for the number column.

I'm guessing I've either missed off some form of grouping stat or the line

%Compliance Status > count%

is somewhat wrong.

For the life of me I'm stumped

Steve

Andrey Khaneev _StiltSoft_

Hi Steve,

Not sure Reporting add-on can build a pivot table. But you can wrap it with Pivot Table macro from Table Filter and Charts add-on, it is compatible with reporting macros.