Katerina Kovriga {Stiltsoft} Expert

Hi @Robbie Ablett , Maybe the last answer of this thread will help.

Hi @Alannes Moura , We can suggest trying our app that is Table Filter and Charts for Confluence and its Pivot Table macro. You'll be able to wrap the Page Properties Report macro in the Pivot Table macro and count the unique page titles.

Maybe you'll be interested in a live demo from our team? Please book an available time slot here. The filtration is similar to the Excel filters - wrap your Jira Issues macro in the Table Filter macro, choose to show filters in the headers and you'll get the filter's icons in the page view mode.

Hi @Stéphane ROUSSAT , Do you mean that you want to show all the project issues on the page via the Jira Issues macro and filter you issues on the fly by dates from the page view mode? If this is the case, then you can try our Table Filter and Charts for Confluence app - its Table Filter macro supports dynamically changing…

Hi @Daizy N , I suppose that the Page Properties/Page Properties Report macros don't support the dynamic Jira Issues macros: the Status macro is not supposed to be automatically updated and the Jira Issues macro fields are not static and reflect the current state from Jira. We have the Table Filter and Charts for…

Hi @Sander , We can suggest trying our app - Table Filter and Charts for Confluence. It provides the Table Excerpt/Table Excerpt Include macros that work somewhat similar to the Page Properties Report macro but allow you to collect multiple-row tables and create one big combined report. This report can be further filtered…

As a workaround, you may use the Sort by option inside the Page Properties Report macro settings or if you use our Table Filter and Charts for Confluence app in your company, then you may wrap the Page Properties Report macro in the Table Filter macro and the table becomes sortable.

A workaround is to sort your result table within the Page Properties Report macro (there is a Sort by field in the macro settings) or wrap your table into our Table Filter macro (the sorting will be available but the app is a paid one).

Maybe you have Server and Data Center? Not Cloud Confluence? Then you won't have such feature.

Hi @Liam Choi , We can suggest trying our app - Table Filter and Charts for Confluence. The add-on provides Table Excerpt/Table Excerpt Include macros that work similar to the Page Properties/Page Properties Report macro but allow you to collect multiple-row tables into one big report. Furthermore with the help of our app…

Hi @Olivier Curti , I've reacted to the "filters on table headers" abstract of your question - maybe you use our Table Filter and Charts for Confluence app and its Table Filter macro? As you can see, our filters in the headers don't prevent the table columns to be sorted by arrows (no matter if this specific column was…

Define the unique Excerpt's name to choose it later with the Excerpt Include macro - this feature is a new one. But you won't see a link to the source page, the Excerpt Include macro doesn't have such option.

It's a limitation for this macro - one (the first one wrapped into the Page Properties macro) reusable table per page. The Excert/Excert Include worked the same way until the opportunity to pull several Excerpts from one page was added for Cloud users some months ago.

Hi @Amelia Zaccara , We can suggest trying our app that is Table Filter and Charts for Confluence and its Table from CSV macro. You'll be able to recreate you Excel table in Confluence using CSV/TSV attachment or URL/Google Spreadsheets. The recreated table looks like a manually created one, and all the changes made to the…

Hi @[deleted] , We can also suggest trying our app - Table Filter and Charts for Confluence. The app provides the Table from CSV macro that allows you to connect CSV files via attachments and URLs (Google Spreadsheets as well) to Confluence. The recreated table can be further filtered, aggregated, recalculated and…

There is no such feature in the Excerpt Include macro. You may try to use Page Properties/Page Properties Report macros that allow you to reuse one-row tables - the PPR macro shows source page titles by default.

If we talk about Table Excerpt/Table Excerpt Include macros that are provided by the Table Filter and Charts for Confluence app, then choose the Page field in the Table Excerpt Include macro settings:

Hi @Roxana , If your glossary is in a tabular form, then we can suggest trying our app - Table Filter and Charts for Confluence. Its Table Filter macro will help you to get precise search results using various types of filters. Our team will be happy to arrange a live demo for you - please book a suitable time slot here.

Hi @Андрей Ионов , You may use the standard Excerpt/Excerpt Include macros. And if you use our Table Filter and Charts for Confluence app in your company, you may try the Table Excerpt/Table Excerpt Include macros that allow you to collect the source page metadata: * page * parent page * space * labels * excerpt * author *…

Here is our documentation about the dates' formats and their correct settings inside our macros. You need to always check the specified date format - our macros "remember" the last used format and when you insert another macro on the page, the date format copies the previous use case. Why do you need to specify the date…

Hi @ejanis , If it happens so that you use our app that is Table Filter and Charts for Confluence in your company, then you may also use its Table Filter macro for filtering your Jira Issues as well. Such dynamic macros are fully supported by our app and you'll be able to use date range filters for your case on the fly…

Hi @Anders Kjöllerström , I assume you have the following case: SELECT SUBSTRING(T1.'Page Title', 1, 10) AS 'Date', * FROM T1 Now your date is a string and the simplest way to perform any manipulations with it as a real date is to use another Table Transformer macro with a correctly specified date format: SELECT…

If you get stuck somewhere, please submit a support request - attach your screenshots of the Jira Issues macro' output, describe the required chart or pivot and we'll guide you through the case.

Hi @Anita Suri , We can suggest using our app that is Table Filter and Charts for Confluence to aggregate and visualize the Jira Issues macro. Our macros "understand" the pretty recent Jira dates correctly and transform them into the standard format. Here is an example: And here are the examples of the Jira dashboards that…

Maybe it's some kind of a bug - I've checked the Excel macro in our test Cloud instance with simple formulas such as (A2+B2) and a standard predefined color scheme for conditional formatting - it worked for me. But we don't use the Excel macro often especially with complex formulas. What concerns our app, we are almost…

Hi @Mik_J , We can suggest trying our app - Table Filter and Charts for Confluence, maybe you've already been using it in your company for filtration and data aggregation. The add-on also provides the Table from CSV macro that supports outputting data from a URL (for example, Google Sheets where you can use your formulas)…

A little update from my side: pay attention that the Chart from Table macro comes after the Table Filter macro, so the rows with empty fields are already filtered and they won't be shown in the chart menu to add them for the values columns. If these empty cells obtain any values, then you should add their sub-category to…

Please add another Table Transformer macro with a default SQL query (just insert it and don't change anything) between the Table Filter and the Chart from Table macros: Then go to the Chart from Table macro and adjust the following settings: Seems it looks similar to your screenshot.

If you get the whole table automatically (through, for example, the Table from CSV or Jira Issues macro) and don't need to show average numbers on the chart, then you may try the following structure: The first table is your macro and the second one is manually created (used for filtering of empty cells if you automatically…

Hi @Petar Todorov , I can suggest the following workaround: The last two rows in each table are used to filter empty cells if there are any. Here we set the dropdown filters and choose their default values as "Empty" and set the reversed filters (so, we get "Not empty" cells). Then we count average for the remaining not…