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?

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Eyal Zmora ,

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

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.

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