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

[#1]

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.

[#2]

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

[#3]

Thanks, this was really helpful.

[#4]

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)

[#5]

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