The chart from table shall count rows instead of summing up values that I have got in the titles

Dirk Derichs
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 21, 2022

I have got a table with 21 entries/rows. If i create a "chart from table" and enter the "title" for the "value columns" I receive currently 21.01, because one row title says "Example 01.01". If i change the 01.01 to 02.00 the chart say I have got 22 values as the chart is summing up the title values instead of counting the rows.

 

How can I get the row count instead of summing up the values in my titles?

 

Example table

Count | Title | Status

1 | John Doe 01.00 | Open

2 | John Doe 01.01 | Open

3 | Jane Doe 01.00 | In Progress

4 | Jane Doe 02.00 | In Progress

 

Expected result: Open 2 | In Progress 2

Current result: Open 2.01 | In Progress 3

1 answer

3 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 21, 2022

Hi @Dirk Derichs,

Please use the following settings for your Chart from Table macro:

Wed 5-1.png

Wed 5-2.png

If you want to present your aggregated data in a tabular way, you may use the Pivot Table
macro:

Wed 5-3.png

Wed 5-4.png

Hope it helps your case.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events