Removing non-data points from box and whiskers chart

I have a four column data set, 2 columns have 5 rows and 2 columns have 3 rows. When I try and make a box and whiskers chart, it adds 2 extra points in the plot for the 2 columns with only 3 data points. How do i get it to only show the correct number of points? I tried the data cleansing tool to remove all the "nulls", but that only removed the "null" text on the x-axis when i first tried.

xtra.point.chart.png

Help

Accepted answers

All comments

gabrielvilella

If you could please share the workflow with the sample data would be helpful. Maybe you need to fill the missing values with something, like zero or the average.

creily

Hi Gabriel,

Just attached a screen shot of the workflow and the excel file. Nothing complicated here, just not sure how to fix.

primary_cell_data.csv

2022-04-20 16_49_22-Re_ Removing non-data points from box and whisker... - Alteryx Community and 10 .png

gabrielvilella

Is this what you want? I just transposed the table.

Chart.yxmd

creily

That was a cool way to solve the problem. Is there a way to change the color of the boxes? I essentially have two groups "HC" and "IgAN"

gabrielvilella

I had to change it to a multiple layer layout, but I could only change the color of the shaded area, the line is still on the original color. Alteryx needs to improve this.

Chart.yxmd

creily

Maybe ill just try and do this in R, this [?] function isn't working on my end.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703