Box and whisker plot in Interactive chart

Hi,

How to create the box and whisker plot for the data 'Location' on x-axis and avg. total pay on y-axis using the sample input shown in Queries-1.png. my input data comes from summarize tool to Interactive chart.

I tried using interactive chart in alteryx designer, created layers but getting the result as shown in attached Queries-3.PNG.

I need the results as shown in attached Queries -2.png.

Queries-1.png - data from summarize tool

Queries-2.png - results should be in this format box and whisker.

Queries-3.png - I am getting this result out of Interactive chart.

Thanks,

Krishna Bommu

Queries -2.png

Queries -3.png

Queries -1.png

Data Investigation

Accepted answers

caltang

Hi @KRISHNABOMMU

This is the best we can do with Alteryx. Colour coding based on a colour gradient doesn't seem to be possible.

Some relevant links:

Box and whisker V1 plot.yxzp

All comments

KRISHNABOMMU

@caltang can you please help me here, if you can...

caltang

Hi @KRISHNABOMMU - I would recommend for the ETL portion to be done on Alteryx, and the visualization done somewhere else (Power BI / QlikSense / Tableau).

Otherwise, if you wish to try Alteryx, I can help you try it too. Do you mind providing me your workflow? Export it for me please (NOT Save As)

To export a workflow go to: Options > Export Workflow.

KRISHNABOMMU

Thanks Calvin Tang! First let me apologize for the delayed response.

I would like to try in Alteryx. do you have any email for me to send the exported work flow.

Thanks,

Krishna Bommu

caltang

Hi @KRISHNABOMMU

Please export it like so:

KRISHNABOMMU

@caltang sorry i did not get it..

caltang

Oh my bad! The image seems to have been corrupted. I meant to export your workflow instead of sending me .yxmd. Kindly send me a .yxzp (exported workflow).

Please refer here: https://www.thedataschool.co.uk/stephanie-kearns/save-alteryx-workflow-packaged-file/

KRISHNABOMMU

here it is.. .yxzp attached. Please let me know if this is fine.

Box and whisker V1 plot.yxzp

caltang

No worries @KRISHNABOMMU - always happy to help the community. You should play around with the workflow I sent you, it does take some tweaking especially with regards to your dimension of choice.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703