Bar Chart

MD2050

Hello Everyone -

We are seeking some direction to to build a graph shown in the 1st snippet below using the (deprecated) charting tool , data is on the left side of the chart. Apparently , we cannot use (I guess) a TEXT field under series, also tried to convert the string to a number with no success - we would need the actual machine names (A,B,C, etc. is for illustrations purposes). I am adding my workflow which I tried to work with , second snippet below shows my progress what we are missing is the "Date" layer we could add to X-axis to show what is depicted in 1st snippet. Thank you in advance. M

T5_Charting.yxmd

Reporting

Accepted answers

gautiergodard

Hey @MD2050

Is it a requirement to use the old charting tool?

I've included a couple alternative solutions using the new interactive chart in the event they can be useful.

T5_Charting.yxmd

All comments

gautiergodard

Hey @MD2050

hard to tell as I’m looking at this from my phone, however firstly, it looks like you need to cleanse the date field so you have a value in every cell.

then I think you’ll want to use the “split” functionality in order to group the machines by dates like in your first graph.

it’s possible you might need to add a new layer to do this.

gautiergodard

Hey @MD2050

Is it a requirement to use the old charting tool?

I've included a couple alternative solutions using the new interactive chart in the event they can be useful.

T5_Charting.yxmd

MD2050

Hello @gautiergodard -

Thank you very much for your solution. We have an older Alteryx version (2019.3) on both desktop application and server and for some reason I thought there will be a compatibility issue while deploying the workflow with new IC tool, I just finished testing the same and it worked - so I think we should be good with this solution.

Thank you very much again for finding time to help us.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703