Scenario

In this recipe, we'll build a report that lists the number of open and resolved comments in each page in a space.

You may also see this recipe in action on our Demo site!

Result

Apps	Reporting
Platform	Server
Level	ADVANCED
Estimated time	minutes ⏱
Macros	And Filter, Content Reporter, Grouping Reporter, Report Column, Report Info, Report Table, Text Filter
Suppliers	Collection Supplier, Comment Supplier, Page Supplier, Space Supplier

You can recreate the example in the editor view:

Create a Report Table macro.
Within the Report Table macro, create a Content Reporter macro and set Types to "page".
Inside the Content Reporter macro, create an And Filter macro.
Inside the And Filter macro add a Text Filter and set Key to page:all comments>collect "inline-status" and tick the Required checkbox.
Add another Text Filter and set the following:
Key to page:all comments>collect "inline-status"
Exclude to .*Dangling.*
Tick the Required checkbox.
Inside the Report Table macro, create a Report Column macro and set the Title to "title/page".
Within the Report Column macro, add a Report Info macro and set the Key to page:title and Link to True.
Inside the Report Table macro, create a Report Column macro and set the Title to "# Open Comments".
Within the Report Column macro, add a Report Info macro and set the Key to page:all comments>collect "inline-status">join with " ">find "Open">size
Inside the Report Table macro, create a Report Column macro and set the Title to "# Resolved Comments".
Within the Report Column macro, add a Report Info macro and set the Key to page:all comments>collect "inline-status">join with " ">find "Resolved">size