How do I specify field order on Column Chart

[CraigF]

I've built a view that renders a stacked column chart by hour. The fields that are stacked come from the "affiliate" field.

 | timechart span=1h count(Order) by affiliate

There are 5 different values (CSR, Web, etc) for affiliate and I want them stacked in a specific order so that I can apply a specific color scheme to them in the stacked chart. I'm handling the color assignment using the following parameter in my view:

<param name="charting.seriesColors">[0xFF0000,0x374682,0xFF8000,0x3B6F03,0x00FFFF]</param>

Short question: how do I manipulate the order of the affiliates in the stacked columns?

[CraigF · Accepted solution]

I figured this out. I just had to pipe the results through

| table _time, CSR, WEB, <redacted>, <redacted>, <redacted>, *

I threw the wildcard on there just in case we add another affiliate in the future.

[I-Man]

What happened to the affiliate field? I have a timechart based stacked column based on a field with two values. I want to re-arrange so they are switched on the stacked column.