nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Graph expects X-axis value in some lexicographical order?

Eyal Zmora

I am trying to display a column graph using "Chart from Table" macro.

My table has 2 columns and looks like this:

Version Duration

V1.20.10 10

V1.20.10.01 20

V1.21.01 4

V1.20.12 10

V1.21.05 20

In this case, only the first 3 versions (V1.20.10, V1.20.10.01, V1.21.01) will be displayed on the X-axis of the graph and I will see only 3 bars, and the 'Duration' values will be wrong.

But when I change "V1.20.12" to "V1.21.02", so now the X-Axis value are ordered lexicographically, everything is displayed fine.

Any idea why?

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Eyal Zmora ,

Give us some screenshots or smth, because that is how it works for me:

Thu 8-1.png

Thu 8-2.png

Seems that everything is displayed as expected.

All comments

Pramodh M

Hi @Eyal Zmora

Change the Version to some numeric field and use the labels for corresponding versions to display on the chart.

Thanks,
Pramodh

Eyal Zmora

Not sure I understand. It does not matter whether Version is a String , a Number or anything else.

If , in the data table, Version is ordered (Numerically or lexicographically), the graph is displayed fine. Otherwise it is not.

Katerina Kovriga {Stiltsoft}

Hi @Eyal Zmora ,

Give us some screenshots or smth, because that is how it works for me:

Thu 8-1.png

Thu 8-2.png

Seems that everything is displayed as expected.

Eyal Zmora

When the data is as follows:

Version	Duration
V4.20.10.03	22
V4.21.05.01	35
V4.21.10	39
V4.21.10.03	49
v45	56

The graph is displayed fine:

But when the data changes to (In Bold is the only change I made):

Version	Duration
V4.20.10.03	22
V4.21.05.01	35
V4.21.10	39
V4.20.10.03	49
v45	56

The graph looks like:

Only 4 bars are displayed, and even for them the values are wrong

Katerina Kovriga {Stiltsoft}

You have the same Versions in the first column of the table - the 1st and the 4th rows.

Their value was summed up: 22+49 = 71 (71 is the first column on the graph).

Eyal Zmora

OMG... What a silly mistake...

Thanks @Katerina Kovriga _Stiltsoft_

Katerina Kovriga {Stiltsoft}

Hi there,

As this Community thread concerns our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

Our new macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

chart

graph