# How to set order of time series columns?

**URL:** <https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 21, 2023, 1:36pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757 "2023-04-21T13:36:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shawn\_Rieger](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn_rieger/32/46336_2.png) [@Shawn\_Rieger](https://forum.inductiveautomation.com/u/Shawn_Rieger)\
**Post date:** [April 21, 2023, 1:36pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/1 "2023-04-21T13:36:21Z")

</div>

I set each column individually under plots\>trends\>columns, but this doesn't work, yo can see the it's displaying BESS 6 SOC and should start with BESS 1 SOC. What are my options here?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/f/cffd5c56fed770991ab7730a74516da41b7fee93.png)

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [April 21, 2023, 3:29pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/2 "2023-04-21T15:29:31Z")

</div>

What order are the columns in your Dataset? I am no expert in the charting aspects of Perspective, but I wouldn't be surprised if the columns directory in _this_ context is not a definition of ordering, but is rather a reference used just to store configurations - unlike the Table, where the ordering of columns in the `columns` array actually orders the columns of the Table.

Update: After reading the [docs for this area](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Time+Series+Chart#:~:text=If%20provided%2C%20only%20the%20columns%20in%20this%20list%20will%20be%20shown.%20Any%20style%20properties%20provided%20here%20will%20also%20override%20any%20existing%20style%20currently%20in%20place.), I see no mention of this setting guaranteeing the ordering of the columns. You might need to order the columns in your actual data to enforce any sort of ordering.

---

<div class="post-metadata">

**Author:** ![Shawn\_Rieger](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn_rieger/32/46336_2.png) [@Shawn\_Rieger](https://forum.inductiveautomation.com/u/Shawn_Rieger)\
**Post date:** [April 21, 2023, 3:44pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/3 "2023-04-21T15:44:36Z")

</div>

The dataset columns are in order  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/1/2179470a54a26ba1c0f8deda7630e18ea1f5b85b.png)

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [April 21, 2023, 3:50pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/4 "2023-04-21T15:50:37Z")

</div>

It works for me... as long as the series' data is an array of objects.  
Same config but with a dataset, and it doesn't work anymore - the columns don't have any effect. can't even change colors.

edit: nevermind... I mistyped one of the headers in the dataset.  
That said, changing the columns order does work on my side.

That's on 8.1.25. Maybe something changed ? What version are you using ?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/147f06f858f2261e3ef05881af0bb03b2112c01f.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/1/a1b0da9a825b9365a23e49241b5c4bceb368b675.png)

---

<div class="post-metadata">

**Author:** ![Shawn\_Rieger](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn_rieger/32/46336_2.png) [@Shawn\_Rieger](https://forum.inductiveautomation.com/u/Shawn_Rieger)\
**Post date:** [April 21, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/5 "2023-04-21T16:23:27Z")

</div>

I'm currently on 8.1.18

---

<div class="post-metadata">

**Author:** ![Aaron\_Bazal](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Aaron\_Bazal](https://forum.inductiveautomation.com/u/Aaron_Bazal)\
**Post date:** [March 19, 2024, 2:01pm UTC](https://forum.inductiveautomation.com/t/how-to-set-order-of-time-series-columns/72757/6 "2024-03-19T14:01:15Z")

</div>

This issue still remains with the default list of dictionaries or a dataset. The chart will enforce the dataset order until the dataset is 10 columns wide or larger and then it will randomize the order.
