Interactive Chart: assign color to single data point

[lostipod12]

Hello,

I have some data going into an Interactive Chart. I'm able to see the data displayed nicely in the chart.

The last piece of this puzzle is to assign a color to the bar of a single data point (single field) which is different than the rest of the bars.

In this case, I want that the value of EMPTY to be red (circled in red above), and the rest of the values remain blue.

Is someone able to point me in the right direction?

Thank you,

Nick

[IraWatt · Accepted solution]

Hey @lostipod12 

You can assign colour here using a colour column:

[lostipod12]

IraWatt,

Thanks so much, that's really slick!

Paraphrased, I can create a custom color column in my data and programmatically assign colors to different data points based on their values.

In my case, using the formula tool I added a new column called NICK_COLOR, then looked for any field where the value was "EMPTY" and assigned the hex version of red; all the other values got the hex version of the default Alteryx blue.

And the results:

When I loaded that data into the Interactive Chart tool, I configured it to take on the NICK_COLOR field to define the colors of each data point:

And the results:

Thanks a bunch,

Nick

[IraWatt]

No worries @lostipod12 :) Glad it all worked for you!