Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to avoid prefix of "Count" or "Sum" on generating charts from Pivot table

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.

2 answers

1 accepted

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:

2019-10-29_10h39_55.png

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*

2019-10-29_10h40_36.png

The result is  the following:

2019-10-29_10h41_17.png

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.

@Ramesh_PS , I'm happy it works for you :)

Hi..

I have another challenge..

I have a table like this..

1.PNG

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..

2.PNG

please advise.

-----------------

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.

2019-12-16_10h52_02.png

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.

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you