Box and whisker plot in Interactive chart

[KRISHNABOMMU]

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

[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 I think it is better to export sample data here instead of the real data if you are concerned.

I do not think it is advisable to go off-site from Maveryx Community. Kindly export it and attach it here if you can. Thanks!

[KRISHNABOMMU]

Here you go.. the workflow attached

[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.