Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?Hi
I’m trying to create a scatter plot in Graph Builder with:
- X = Rch
- Y = Cov
- Group = LOT_WF
What I want is:
For each LOT_WF, a single point representing
(median(Rch), median(Cov))
So the final plot should have one point per LOT_WF, not raw data.
What I tried
- Added Points element and changed Summary Statistic → Median
- Used Overlay = LOT_WF
But the result still shows scatter points or only partially aggregated values.
It seems like Graph Builder is not aggregating both X and Y simultaneously by group.
My question
Is it possible in Graph Builder to:
Aggregate both X and Y as median by group
And directly plot (median(Rch), median(Cov)) as one point per LOT_WF
without creating a separate Summary table?
Additional context
I know I can achieve this using Tables → Summary, but I’m looking for a way to do it directly in Graph Builder for interactive analysis.
Basic Data Analysis and ModelingRe: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?You can create new formula to your table or transform column within graph builder
1. Right click on LOT_WF -> Group By
2. Right click on Cov -> Aggregate > Median
3. Use that new column as your X-axis
Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?I would use Transform Columns within the Graph Builder.
Using Car Phyical Data as an example: Create a scatter plot of, say, Horsepower vs Weight, with Overlay=Country. Notice that changing the scatterplot to Summary Statistic: Median does not work, just as you said.
Now, right click on Weight -> Default Scope -> Overlay. This tells the Graph Builder that your next Transforms should be grouped according to the Overlay variable, Country. Next, right click Weight again and create a Median transform column. Repeat with Horsepower. Use these new Median(Weight) and Median(Horsepower) variables as your new X and Y variables. This should produce the desired plot.
--> 
Let me know if this works for you!
(By the way, this is exactly the same as @jthi 's solution, except it is done within the Graph Builder instead of creating new columns in the data table)
Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?Thanks, this was really helpful.
Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?Thanks, this is really helpful. I can now analyze medians while switching overlays — this is exactly what I needed.
