Grouping field in Scatter plot

While using Scatter plots (Data Investigation tool), under Plot Elements tab, while checking the check box "plot by groups" option and using "grouping field", how to differentiate the values of "Grouping field" by different color. For example: if you have grouping field called Smoker how to differentiate the values Smoker and non smoker by different colors. is there any option ?

Scatterplot- Impact of Age and smoke on claim.pdf

Data Investigation

Accepted answers

alexnajm

Try the Interactive Chart tool! You can build a Scatter plot from there and you should have a grouping option to help out

alexnajm

Theoretically yes - you should be able to plot two variables (age and claim) while using the smoker vs non-smoker as a grouping variable. This article gives one idea: How to Group Data by Color in an Interactive Chart - Alteryx Community

alexnajm

Great news @KRISHNABOMMU!

alexnajm

@KRISHNABOMMU If the attached is what you were looking for, then that's great!

All comments

alexnajm

Try the Interactive Chart tool! You can build a Scatter plot from there and you should have a grouping option to help out

KRISHNABOMMU

Thank you for letting me know that scatter plot can be done using interactive chart!

Further, i would like to know if i can plot three variables Age, Smoker (or not) and Claim using interactive chart. that is i would like to show the impact of Age and smoking habit on Claim value ( Please attached picture for reference)

Scatterplot- Impact of Age and smoke on claim.png

KRISHNABOMMU

Thank you for letting me know that scatter plot can be done using interactive chart!

alexnajm

KRISHNABOMMU

thank you much! 🙏 i will try what you said and let you know.

KRISHNABOMMU

Hello Alex,

I was able to produce the expected result as per the idea given in the article you shared with me. I am attaching the results of the same in the word document.

Thanks much for your help!

Note:i was able to do in a couple of days after you shared the link, now sharing with you after a week of vacation.

Scatterplot- step by step.docx

alexnajm

Great news @KRISHNABOMMU!

KRISHNABOMMU

I know you should be busy. still when you get a chance, please have a look at the attached results documentation of the scatter plot and let me know your valuable suggestions.

TIA,

Kind regards,

Krishna Bommu

alexnajm

@KRISHNABOMMU If the attached is what you were looking for, then that's great!

KRISHNABOMMU

Thank you very much @alexnajm ! Actually i learnt alteryx from udemy videos from course Alteryx boot camp for 6.5 hrs and had hands on the use cases from kaggle using the Alteryx trial version. that is where i asked the doubts on scatter plot. now i am looking for what should i do next in the learning further? Any suggestions is very much appreciated?

Kind regards,

Krishna Bommu

alexnajm

I would suggest all of the Interactive Lessons on the Community! That is how I learned Alteryx years ago. Beyond that there are many other resources such as videos and Learning Paths on the Community to help in your journey.

KRISHNABOMMU

Thanks Alex!

KRISHNABOMMU

Thank you so much for the suggestion! I appreciate that.

I work in mainframes technology in IT industry.

i am considering a switch to Alteryx and learnt the same. I wanted to know if learning ALTERYX alone is sufficient

or i should learn any additional technology like tableau, SQL etc is required to get a job/career related to ALTEYX?

Thanks,

Krishna Bommu

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 the box and whisker needs all of the information before being summarized so that it can calculate the mean, quartiles, min, max, etc. I recommend not summarizing to just averages beforehand

KRISHNABOMMU

Thank you @alexnajm ! so kind of you to provide your suggestions. 👍

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703