Katerina Kovriga {Stiltsoft} Expert

You may also consider using the Table from CSV macro (Table Filter and Charts for Confluence app). You'll be able to transform your CSV attachments into Confluence tables and connect your Google Sheets (Google Drive) directly via its URL. It is more convenient, especially for big tables.

Hi @Paulo Barbosa , You'll need additional apps to perform calculations in Confluence, there is no such feature out-of-the-box. For example, you may try the Table Filter and Charts for Confluence add-on. It provides several macros that will help you with different cases: * Table Filter (filters your tables, and allows to…

Hi @[deleted] , We know about such behavior of the standard Chart macro with the dynamic content, for example, when you use it with the Jira Issues macro, Page Properties report macro, etc. As it renders only static data, you'll see a beautiful graph in the preview but nothing after publishing the page. In such cases we…

Hi @Kristine McKinney , The standard Chart macro is not compatible with dynamic tables, it doesn't show the result (or sometimes the preview is beautiful but you don't get your graph when the page is published). What kind of tables (or maybe another Confluence macro) do you wrap into the Chart body? You can use the Chart…

And what is the app version? 6.0.1 is the current one. And the up-to-date Confluence Server version is 7.8 (look here). It seems that a simple update may help your case.

We've checked your case both on our Cloud and Server instances - everything works ok. Is your hosting a Cloud one as it is shown in the description of the question? Maybe it is a mistake, and you use an old Server Confluence and outdated version of the Table Filter and Charts app?

Please, try to recreate everything on the new page. If this doesn't help (it seems like you are doing everything right and it should be working), raise a support ticket, we'll try to investigate the issue more thoroughly.

And we also choose just the Story Points field to show in the Jira Issues macro configuration - so you're doing everything right:

And how does your empty Jira table look without the Table Transformer? It should be like this - your Story Points heading and an empty line. It seems that smth is wrong with the Jira Issue macro, the Table Transformer can't recognize it as a proper table (the screenshot below is taken from the view mode of my test page).

Hi @Surya Anem , We've recreated your case and used your original query for the Table Transformer. The first Jira Issues macro: no filtered results, empty table The second Jira Issues macro: a table with results The preview of the Table Transformer macro As you can see, everything works just fine. Maybe we don't get what…

Hi @Jez , You may try the Table Filter and Charts for Confluence app. Wrap your Jira Issues macro in the Table Filter macro body and set the required filters: Now your users can find whatever issues they need easily. If you are used to Excel/Spreadsheets experience, you'll may use our live filtration. You'll be able to set…

Hi @Gigi Delacruz , There is no such feature out-of-the-box in Confluence (both for Cloud and Server/DC). Try to browse the Marketplace and find the corresponding app. For example, we can recommend to use our Table Filter and Charts for Confluence app.You'll be able to use filters, create pivots, count sums/average…

Here you are:

Hi @Marcin Lis , It's a strange behavior for the export functions, especially if you are referring to the one particular table. Try to recreate it on another page and check if the export is working. We also recommend to update the app to the latest version (6.0.1 as for now). We have a new feature in the 6.0 major version…

Hi @Pravin Dharmik , You may try the Table Filter and Charts for Confluence app. Wrap your table in the Pivot Table macro and aggregate the required data:

Hi @Jo Guthrie , You may try the Table Filter and Charts for Confluence app. Use the Table from CSV macro and create tables in Confluence based on the CSV attachment or URL. Further on you'll be able to filter your table, create pivots and visualize you data with the help of other handy macros that you get with the addon.

Hi @Mauro Gobbi , I've tried to do the same thing with the standard Chart macro and got similar results - the Time Period doesn't affect my scale at all. Month: Quarter: So I can recommend to try our app (maybe you've already got it for your instance) - Table Filter and Charts for Confluence. Wrap your tables in the Chart…

And here is another option to connect you Google Sheets to the Table from CSV macro via a URL: Step 1 Go to the Publish to the web tab Step 2 Choose the CSV type and allow other users to see it Step 3 Get the required URL for the Table from CSV macro

A quick update about the Table Filter and Charts for Confluence app: export the whole table or use the live filtration (set filters on the fly in the view page mode) and get the filtered result in CSV, PDF and Word. Live filtration in the view mode: Filtering on the go: Exporting of the filtered table:

You may also try the the Table Filter and Charts for Confluence app for table export. Export the whole table or use the live filtration (set filters on the fly in the view page mode) and get the filtered result in CSV, PDF and Word. Live filtration in the view mode: Filtering on the go: Exporting of the filtered table:

You may try the the Table Filter and Charts for Confluence app: export the whole table or use the live filtration (set filters on the fly in the view page mode) and export the filtered result in CSV, PDF and Word. Live filtration in the view mode: Filtering on the go: Exporting of the filtered table:

And a quick update about the Table Filter and Charts for Confluence app: now you can export the whole table or use the live filtration (set filters on the fly in the view page mode) and export the filtered result in CSV, PDF and Word. Live filtration in the view mode: Filtering on the go: Exporting of the filtered table:

You may try the the Table Filter and Charts for Confluence app: export the whole table or use the live filtration (set filters on the fly in the view page mode) and export the filtered result in CSV, PDF and Word. Live filtration in the view mode: Filtering on the go: Exporting of the filtered table:

Hi @Brian_Mihok , You may try to use the Table Filter and Charts for Confluence app. Wrap you Jira Issues macro in the Table Filter macro and set the required filters: You don't need to change your JQL query in the Jira Issues macro - just show all the fields. Regular users will find (filter) everything they need in the…

Hi @Oren Iny , You may try the Content Table Report macro combined with the Table Filter and Charts for Confluence app. Here is a 2-minute tutorial how to count and visualize the creators and the number of created pages.

Hi @Sandhya Srinivasan, As usual, we recommend our own app - Table Filter and Charts for Confluence. But import/export of tables in the CSV format is just one of its capabilities besides filtering, creating pivots, generating charts, performing calculations, etc. So, this add-on is a paid one. But you can browse the…

Hi @Gireesha Jeera Use the "today" function: SELECT *, CASE WHEN ("today" - 'Target date') / "24h" < 5 THEN "ON TIME" WHEN ("today" - 'Target date') / "24h" > 5 AND ("today" - 'Target date') / "24h" <= 10 THEN "LATE" ELSE "VERY LATE" END AS 'Rating' FROM T1

Hi @Joel Tabares , It seems that's a duplicate question for this one. Let me repeat the answer here: There are two options to resolve your case: the Table Transformer macro and the Pivot Table macro. Option 1. Table Transformer Use the following custom SQL query: SELECT T1.'Project', SUM(T1.'Remarks' + " ") AS 'Remarks'…

Hi @Joel Tabares , There are two options to resolve your case: the Table Transformer macro and the Pivot Table macro. Option 1. Table Transformer Use the following custom SQL query: SELECT T1.'Project', SUM(T1.'Remarks' + " ") AS 'Remarks' FROM T1 GROUP BY T1.'Project' Option 2. Pivot Table Recreate the settings from the…

Hi @Paul Dinka , We can recommend to use our app - Table Filter and Charts for Confluence. Let's imagine that here is your source table where you will change the values: The cost of the ProductA1 will be required in the second table but you don't want to correct it twice: Let's switch to the edit mode: Here is your first…