How to automatically count string values from a table that are to be used in a new table for charts

unknown

Hello Confluencers  

I am trying to find a way to automate the counting of specific string values from a table. Based on that count, I want to generate a new table to display the number of occurrences of each string value and use that to generate a chart. Is there any way to automate that? 

 

Big thanks in advance!

Stiltsoft support

Hi @[deleted],

We can suggest trying the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

You may reuse your source table as many times as you need with the help of the Table Excerpt/Table Excerpt Include macros.

Then you may wrap each Table Excerpt Include macro in the Table Toolbox macro (a special shell for macro nesting due to the Cloud editor limitation) and apply the Pivot Table/Table Transformer macros for aggregation and calculations. Then you apply the Chart from Table macro and create a graph based on your transformed table.

So, you'll be able to update your source table, all the changes will be passed through our macros, and your charts will be always up-to-date.

Besides, we support not only manually created tables but macro generated as well (for example, Page Properties Report and Jira Issues).