# Sorting a Box and Whisker chart

**URL:** <https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012>\
**Category:** Ignition\
**Created:** [February 15, 2014, 6:27pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012 "2014-02-15T18:27:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [February 15, 2014, 6:27pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012/1 "2014-02-15T18:27:34Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [February 17, 2014, 12:44pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012/2 "2014-02-17T12:44:22Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [February 18, 2014, 12:45pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012/3 "2014-02-18T12:45:19Z")

</div>

anyone, bueller?

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [February 18, 2014, 7:36pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012/4 "2014-02-18T19:36:45Z")

</div>

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

```auto
"#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"
```

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/b/4bc1987844658b5cb47d00e1a1863bd494ed5a5c.jpeg)

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [February 24, 2014, 8:38pm UTC](https://forum.inductiveautomation.com/t/sorting-a-box-and-whisker-chart/8012/5 "2014-02-24T20:38:29Z")

</div>

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