HI,
I am creating few charts (Pie) using the pivot tables and getting the prefix like "Count" and "Sum".
Unable to find a way to have column labels displayed without such prefixed in chart.
Please advise.
Hi @Ramesh PS ,
You can use the Table Transformer macro for this purpose. Wrap the Pivot Table macro in the Table Transformer macro, rename columns and build a chart based on the transformed table:
Use the the similar SQL query:
SELECT 'Column 1', 'Sum of Column 2' AS 'Column 2', 'Sum of Column 3' AS 'Column 3' FROM T*
The result is the following:
Please let me know if you have any further questions.
any other alternative if Table Transformer Macro is not available?
The Table Transformer macro is included in the Table Filter and Charts app as well as the Pivot Table and Chart from table macros. This macro is available starting from version 5.0 of the app.
Unfortunately, there are no options to rename table columns except this macro.
Thanks This helps.
Chart legend gets rid of "Sim of" starting from version 5.3.0 of Table Filter and Charts.
Hi.. thanks..
is it by design or do we have to manually setup?
can I get rid of Table Transformation macro in this case?
It is by design, no setup is needed. All values in the legend get rid of a common prefix when the chart is built on the basis of the Pivot Table macro.
Hi @Ramesh PS,Starting with the Table Filter and Charts for Confluence version 9.6.0 (Server/Data Center) and 20 Dec, 2022 for Cloud, we’ve made an improvement to the Pivot Table macro: such prefixes as “Sum of …”, “Literal of …” etc. can be eliminated.
It looks like you're new here. Sign in or register to get started.
