Reporting Cloud app allows you to filter your report results in two ways.
Filtering your raw fetched results
You can use CQL (Confluence Query Language) in the Query section as a starting point to filter results. 
Here are some example queries:
| Query result | CQL |
|---|---|
| Matches all pages within the "KBASE" space. | type=page and space="KBASE" |
Matches all pages within the current space. | type=page and space=currentSpace() |
Matches all comments within the "KBASE" space and in on the current page. | type=page and space=currentSpace() and content=currentPage() |
| Matches all pages with the label "profile_page". | type=page and label="profile_page" |
| Matches all pages created by the current user. | type=page and creator=currentUser() |
| Matches all pages with the label "profile_page" which were modified after the start of this year. | type=page and label="profile_page" and lastModified > startOfYear() |
...
Advanced filtering for your final report results
Reporting allows you to apply advanced filters using JMESPath. JMESPath is a JSON manipulation tool that will enable you to transform further and filter results to provide better control over the final results and how they are formatted and shown on your report.
To add a JMESPath filter, go to the Filters section and click Add. Key in or paste the JMESPath string. You can also add more than one filter, and filters are applied from top to bottom.
You can change the order of filters by dragging them up or down. Then click Apply to use the filters.
In the example below, two filters are being used.
JMESPath is geared towards more advanced users and requires report builders to understand and familiarize themselves with the syntax. We have documented a few commonly used filters below.
| Filter result | JMESPath |
|---|---|
Show only the first "5" results | [:5] |
| Only display the second result from the return CQL | [[1]] |
| The result should match the exact title of 'Product catalog' | [?content.title=='Product catalog'] |
| The title should start with the word "Product" | [?starts_with(content.title, 'Product')] |
| The content body must contain the text 'Product' (make sure 'body.storage' is added into your expansions) | [?contains(content.body.storage.value, 'Product')] |