turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Show Discreet Values with Graph Builder Using Lines

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 12, 2015 7:55 PM
(3396 views)

Hi,

I am working with a large data set, and I am using Graph Builder to display the results. My problem is that if I use lines on Graph Builder to display the data, there is some smoothing taking place, and the shape of the line does not accurately represent the data. If I use dots on Graph Builder, the data is accurate, but it is a little hard to see. I can use the Overlay platform to achieve lines that accurately display the fine shape of the data, but the Overlay platform does not filter data as cleanly as in Graph Builder.

Does anyone have any suggestions about how I can use Graph Builder to accurately display the fine shape of the data? I am using JMP11.

Thanks!

Names Default To Here**(** **1** **)**;

dt = New Table**(** "Data",

Add Rows**(** **1000000** **)**,

New Column**(** "X", Numeric, Continuous, Format**(** "Best", **12** **)**, Formula**(** Row**()** **)** **)**,

New Column**(** "Y", Numeric, Continuous, Format**(** "Best", **12** **)**, Formula**(** Sequence**(** **1**, **4**, **1**, **100** **)** **)** **)**,

New Column**(** "Group", Numeric, Ordinal, Format**(** "Best", **12** **)**, Formula**(** Sequence**(** **1**, **4**, **1**, **1** **)** **)** **)**

**)**;

graphLines = dt << **Graph Builder(**

Show Control Panel**(** **0** **)**,

Variables**(** X**(** :X **)**, Y**(** :Y **)**, Group Y**(** :Group **)** **)**,

Elements**(** Line**(** X, Y, Legend**(** **7** **)**, Row order**(** **0** **)**, Summary Statistic**(** "Mean" **)** **)** **)**,

Local Data Filter**(** Location**(** **{****0**, **0}** **)**, Add Filter**(** columns**(** :Group **)** **)**, Mode**(** Select**(** **0** **)**, Show**(** **1** **)**, Include**(** **1** **)** **)** **)**,

SendToReport**(**

Dispatch**(** **{}**, "Graph Builder", OutlineBox, **{**Set Title**(** "Graph Builder with Lines" **)}** **)**,

Dispatch**(** **{}**, "X", ScaleBox, **{**Min**(** **335000** **)**, Max**(** **338000** **)**, Inc**(** **200** **)**, Minor Ticks**(** **1** **)}** **)**

**)**

**)**;

graphDots = dt << **Graph Builder(**

Show Control Panel**(** **0** **)**,

Variables**(** X**(** :X **)**, Y**(** :Y **)**, Group Y**(** :Group **)** **)**,

Elements**(** Points**(** X, Y, Legend**(** **8** **)**, Jitter**(** **0** **)** **)** **)**,

Local Data Filter**(** Location**(** **{****0**, **0}** **)**, Add Filter**(** columns**(** :Group **)** **)**, Mode**(** Select**(** **0** **)**, Show**(** **1** **)**, Include**(** **1** **)** **)** **)**,

SendToReport**(**

Dispatch**(** **{}**, "Graph Builder", OutlineBox, **{**Set Title**(** "Graph Builder with Dots" **)}** **)**,

Dispatch**(** **{}**, "X", ScaleBox, **{**Min**(** **335000** **)**, Max**(** **338000** **)**, Inc**(** **200** **)**, Minor Ticks**(** **1** **)}** **)**,

Dispatch**(** **{}**, "400", LegendBox, **{**Position**(** **{****0}** **)}** **)**

**)**

**)**;

overLines = dt << **Overlay Plot(**

X**(** :X **)**,

Y**(** :Y **)**,

Grouping**(** :Group **)**,

Connect Points**(** **1** **)**,

Local Data Filter**(** Location**(** **{****0**, **0}** **)**, Add Filter**(** columns**(** :Group **)** **)**, Mode**(** Select**(** **0** **)**, Show**(** **1** **)**, Include**(** **1** **)** **)** **)**,

SendToReport**(** Dispatch**(** **{}**, "101", ScaleBox, **{**Min**(** **335000** **)**, Max**(** **338000** **)**, Inc**(** **200** **)**, Minor Ticks**(** **1** **)}** **)** **)**

**)**;

graphLines << **Journal**;

graphDots << **Journal**;

overLines << **Journal**;

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In JMP 12 the Graph Builder lines look "right" out of the box; it plots slower but without the automatic interpolation that happens in JMP 11 for large data sets.

If you reduce the number of rows (e.g. by truncating or summarizing) the stepwise line pattern will be correctly displayed in JMP 11 too. I tried to reduce the number of rows to 100000 and then it looked OK.

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In JMP 12 the Graph Builder lines look "right" out of the box; it plots slower but without the automatic interpolation that happens in JMP 11 for large data sets.

If you reduce the number of rows (e.g. by truncating or summarizing) the stepwise line pattern will be correctly displayed in JMP 11 too. I tried to reduce the number of rows to 100000 and then it looked OK.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Thanks MS. Looks like I will have to deal with the problem until I can upgrade to JMP12. Thank you for the input.