My group reporter is grouping

  • 1
  • Question
  • Updated 2 years ago

I am using Group Reporter to count entries in a table, the table is calculating the information but the information is not grouping properly. From all of the examples I have looked at, everything looks right. I am attaching the picture of the table and the mark-up.  I am trying to counting the number of times a person in the Writer column selects the fields in Task and Status, I have the filters in the columns to capture the correct selections, I just need to group the content with the writer. This is what the table looks like

The data information for the table is:

The table data name is:ProductProfiles2016

The field name for Writer is: Writer

The field name for Task is: task

The field name for Status is: Status


 


<p> </p>
<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>
        <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>
        <p> </p>
        <p> </p>
        <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: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: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">.*In 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">
                        <ac:parameter ac:name="include">.*New.*</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">.*In Progress.*</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>
            <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">New 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">.*New.*</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">

Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
  • hopeful that this is a simple error

Posted 2 years ago

  • 1
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Martrice,

Kindly please add below {text-sort} in your {local-reporter}:
{text-sort:data:Writer}
You'll need to sort Writer before grouping it using {grouping-reporter}. Hope this helps!

Thanks&Regards,
Ziana
Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
That worked, I actually thought I had tried that, but in any case, problem resolved, thanks.
Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
One more question, how can I total the columns. Typically on a column you would use data:... in the Summary field but since this is a grouped,  grouped:@items isn't working?