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
- :
- Unlocking the power of Graph Builder

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

Unlocking the power of Graph Builder

Aug 29, 2014 6:32 AM
(1867 views)

I have a session at Discovery Summit next month called "Unlocking the power of Graph Builder". I've posted a few slides already, but it will mostly be a live demo. After reviewing the architecture and how the components work together, I'll show how to build a few different graph types, some of which may not be so apparent.

My open-ended question is, are there requests for particular kinds of graphs to show? Or particular kinds of data to show? It could be something that you thought took you too long to figure out or that you still haven't figured out.

Don't make me use Big Class!

9 REPLIES

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

Re: Unlocking the power of Graph Builder

Xan,

From your slides it looks like you will cover the "drop" zones which is great. Please be sure to include where the "order by" zone is and how the "nesting" of factors work (if you drop to the right vs. to the left of a grouping variable). Demonstrating how to use the various error bars would be helpful (e.g., how to use error bars and still see all of the data points) and the labeling of bar charts (in particular, %'s).

Karen

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

Re: Unlocking the power of Graph Builder

Thanks, Karen. The "order by" drop zone is at the top of the list of (unfortunately) hidden features. I'll be sure to cover many bar chart options and styles, too.

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

Re: Unlocking the power of Graph Builder

Would it be possible to have your presentation posted on the JMP site as an on-demand video? I really like the on-demand videos and I have noticed that the ones already posted are getting pretty old! Need new ones!

Steve

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

Re: Unlocking the power of Graph Builder

Hi smoore2,

Great minds think alike.

We'll be recording a number of the presentations from Discovery Summit 2014.

After the conference we'll be posting them.

-Jeff

-Jeff

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

Re: Unlocking the power of Graph Builder

Xan,

It would be great if Graph Builder could be extended to create a heat map graph, like the one shown below. I've programmed it in JSL, but there are elements of it that are a bit slow. The Heat map shows individual rectangles which are time slices for separate categories. The Y variable is shown as a color, the x axis is time. The nice thing about this graph is that it allows you to visualize many groups at once, over time.

In the example below, each rectangle represents a categorical variable, in this case PT Name. PT stands for Preferred Term, which in the pharma world means a drug side effect. The color shows a particular value for each PT name over time.

By the way, I got the idea for this chart from my first JMP Discovery conference in 2010. Someone wanted to visualize the performance of 100 stocks over time, all on the same chart, and this is what they came up with!

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

Re: Unlocking the power of Graph Builder

Thanks, Peter. I vaguely remember that. Here's my GB attempt using Group Wrap after stacking and standardizing the columns.

I suppose I could get rid of the group level labels completely by recoding them as whitespace characters.

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

Re: Unlocking the power of Graph Builder

Wow that's fantastic! I didn't think GB could do that. Can you share the code or steps involved? I would probably keep the group level labels.

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

Re: Unlocking the power of Graph Builder

- I started with 12 data tables, each with a year of stock prices.
- I Concatenated them, keeping the source table as a new column. Alternately, if you have one table with 12 Y variables, you would Stack them into one column.
- I created a row number column, which is within source table. That is, it went from 1 to about 250, 12 times.
- I created a standardized price column called "Value".
- Then I could create the graph with source table as Group Wrap, row number as X and Value as Color.
- Change element type to Heatmap and then change the axis to have an minor increment of 1.

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

Re: Unlocking the power of Graph Builder

My journal file and most of the supporting files are now available in the section of the User Community:

Unlocking the Power of Graph Builder