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

[caltang · Accepted solution]

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:

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Sort-and-produce-Whisker-diagr...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Interactive-Chart-Box-Whiskers... 

[KRISHNABOMMU]

Thank you so much @caltang .  you are always helpful. i wll take a look at the solution and get back to you if i have any queries.

Kind regards,

Krishna Bommu

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