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.
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.
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.
I have another challenge..
I have a table like this..
and using a simple query to rename the column names..
SELECT "RAG Status" as "RAG", "JIRA Phase" as "Phase", "Count Business Solutions" as "BS" FROM T1 (Tried T* also)
but getting the output as show below and not retaining the actual data after renaming the column name..
Will it be possible to assign a name to a table .. either created Manually or with table view macro to display form data or a Pivot table..
I am trying to use custom table name instead of T1 or T* that can be confusing at times.
Hi @Ramesh_PS ,
In SQL syntax the double quotes character means a value while the single quote character means a column label. So please try the following query:
SELECT 'RAG Status' AS 'RAG', 'JIRA Phase' AS 'Phase', 'Count Business Solutions' AS 'BS FROM T1
One more hint is when you type T1. you can see all the columns from the first table and just click to select the column.
Regarding your question about renaming tables, unfortunately, there is no such feature in the app. T* means all tables within the Table Transformer macro body; T1, T2, etc. means the particular table number in order within the Table Transformer macro body.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events