topic Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)? in Discussions

Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?

bumkim — Mon, 13 Apr 2026 03:12:28 GMT

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.

Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?

jthi — Mon, 13 Apr 2026 04:07:15 GMT

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)?

christian-z — Mon, 13 Apr 2026 14:08:13 GMT

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)?

bumkim — Fri, 17 Apr 2026 08:10:42 GMT

Thanks, this was really helpful.

Re: Graph Builder: How to plot median(Rch) vs median(Cov) by group (LOT_WF)?

bumkim — Fri, 17 Apr 2026 08:10:53 GMT

Thanks, this is really helpful. I can now analyze medians while switching overlays — this is exactly what I needed.