Reporting counting number of occurances

[Steve Boydon]

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

[JK Kim]

.

[Steve Boydon]

Thanks for the response Andrey. Unfortunately the organisation I am working for are not currently purchasing additional addons.

To add to this Service Rocket are taking down their old support forum, so historic 'answers' will go.

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.

[JK Kim]

Can automatically fill the the bottom row ? (count)
It adds the specific each text.

name	2/01(월)	2/02(화)	2/03(수)	2/04(목)	2/05(금)	2/15(월)	2/16(화)	2/17(수)	2/18(목)	2/19(금)
A	-	원격	-	-	원격	-	-	-	-	-
B	원격	-	원격	-	원격	원격	-	원격	-	원격
C	-	원격	-	원격	원격	-	원격	원격	-	원격
D	-	원격	-	원격	원격	-	원격	원격	-	-
count	원격:1,  -:3	원격:3 -:1	원격:1,  -:3	~	~	~	~	~	~	~

[Katerina Kovriga _Stiltsoft_]

Hi @JK Kim ,

If you need to count cells with text (not numbers!), it is also possible with the Table Filter macro.

Wrap your table in the macro body, go to the macro settings -> Table View -> Count totals for columns and choose to count not empty cells for any columns you want:

Hope this helps your case.