Sorting a Box and Whisker chart

Ignition
1

I have a Box & Whisker chart with the following dataset:

Seconds, Value
68885, 80.89687246019425
68885, 137.24251091480255
68885, 67.45794415473938
68875, 66.9175237417221
68875, 135.41695475578308
68875, 80.5865665897727
68866, 81.51920009506205
68866, 102.58692502975464
68866, 68.28900426626205
68856, 70.49749791622162
68856, 140.8250629901886
68856, 82.39142694971063
68847, 88.61940564407458
68847, 152.7724415063858
68847, 73.23633879423141

The dataset is a query from MSSQL 2008R2, there is an order by on the first column as is shown in the resultset but the chart dataset randomly orders the items as seen in the chart below. Is there anyway to set the order of the results in the box & whisker chart?

2

Just a follow up, I am still unable to get the chart to sort, i tried the sortDataset() expression function which had no effect.

I tried calling support this am but looks like there closed for the holiday.

Any help or suggestions are appreciated, thanks!

3

anyone, bueller?

4

Try “pivoting” your data. Paste this into the dataset for the chart:

"#NAMES"
"68885","68875","68866","68856","68847"
"#TYPES"
"F","F","F","F","F"
"#ROWS","3"
"80.89687","66.91753","81.5192","70.4975","88.61941"
"137.24251","135.41696","102.58692","140.82506","152.77245"
"67.45795","80.58656","68.289","82.391426","73.236336"

699×188 25.4 KB

5

I’m testing it out, ill let you know how it goes