Sort Chart data in Chart from table

ksweeney

I have a table with columns showing different runs and rows showing the results for accuracy, precision, recall and F1 score. I have my table within a "Table Excerpt".

 

I then have a "Chart from table" macro, which has a "Table Excerpt Include" macro inside. (see below)

The values are then shown in the chart are ordered alphabetically as shown (Column names left out)

I want to be able to order the results on Precision so the chart for precision will go from largest to smallest and then all others (i.e. Accuracy, Recall and F1) will then just follow the sorting order. 

 

I am a complete newbie to Confluence so please either excuse the simple question or reply explaining all required steps.

 

Many thanks!

Stiltsoft support

Hi @ksweeney ,

The macro works as expected, it's a standard behavior.

Not sure if the case can be implemented in general because, as I see, for the Accuracy field it may be ABCDE, for Precision - CBDAE, for Recall - EBDAE and so on. The original table can't be even sorted in a way to maintain "from largest to lowest" separately for each field.

The workaround may be to break your table by fields and create a separate chart for each field.