cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Practice JMP using these webinar videos and resources. We hold live Mastering JMP Zoom webinars with Q&A most Fridays at 2 pm US Eastern Time.See the list and register. Local-language live Zoom webinars occur in the UK, Western Europe and Asia. See your country jmp.com/mastering site.

Choose Language Hide Translation Bar
Creating Custom Drill Down Graphs to Enhance Interactive Reporting

When you hover over a visual element in a graph, usually you see a basic description of the data point in a Hover Label. You can also easily add one or more levels of interactive graphs with data point infomation to a Hover Label using Graphlets. These drill-down graphs are predefined and editable. Note: Hover Labels are saved to interactive html. Drilling into Graphlets requires JMP or JMP Pro, so Graphlets are available when you save to formats that include JMP data, like JMP Projects, Journals and Applications.  Custom drill-down graphs are not available when you save and share interactive html outside of JMP.

 

 

 See how to:

  • Understand and view samples of JMP Hover Labels

  • Use hover labels in Graph Builder drill-down graph sequences of pop-up information about data points

  • Build drill-down graphs for airline data

  • Use Graph Builder and Selected Formula to Locate points on one graph and compare to rest of the group on another graph

  • Edi Gridlets to remove data from drill-down graph

  • Define the drill-down views by building the views from the bottom up (starting with last graph in drill-down sequence first) similar to nesting Russian dolls

See Lovy Singh's short video on saving nested graphs.

 

Questions answered at live webinar by Lovy @Lovy_Singh  and @O_Lippincott:

Q: In the first example, how did JMP know Month and Day were hierarchical and to display them when choosing a line graph instead of some other variable on the x axis?

A: JMP is looking by default for the next column in the data table. There is a column property to define the hierarchy called "Next in Hierarchy".

 

Q: How do you have the column details (column name and distribution bar graphs) show on top of the table?

A: The header graphs you are seeing at the top of the table can be turned on by clicking the histogram icon (grey-green icon in the upper left of the data table near red triangle) with JMP 15 or newer.

 

Q: The standard data set for airline incidents doesn't have "Last[Location]". How did you get that column?

A: From my Location column, R-click, then choose New Formula Column>Character>Last Word.  Then the last work gives you a column with State Abbreviations.

 

Lovy_Singh_0-1695230316554.jpeg

 

Using Formua to Create a Last Word Column

 

 

Q: Is my understanding correct that the nested graphs are pasted as pictures in clipboard. Are they  interactive?

A: The drill down graph becomes interactive when you click on the hover label of the graph and then it becomes a full size graph in Graph Builder, Tabulate or any other platform that you choose.

 

Q: Can you use the selected column to choose what is shown in tabulate?

A: Yes, there are ways to choose what is shown in Tabulate. There is a column property called "Next in Hierarchy" to choose which column appears next. There is also the ability to copy a graph to the clipboard and choose Paste Graphlet to add a custom tabulate as the next view.

 

Q: After a graph has been created (let's say a time series),  and you use the zoom/magnifier tool to check a specific portion of the graph, how do you zoom out back to the original X and Y values when the graph was created (not using Windows zoom out)?

A: If you ever get lost anywhere in your axis views (in Y or X) in GB you can  Right-Click on the axis, and select Revert Axis and it will take you back to default original view.

 

Q: In addition to the drill-down graph, how can I plot data from each city on a separate graphs?

A: That basic Graph Builder question is covered in this video and documentation. https://community.jmp.com/t5/Mastering-JMP/Understanding-and-Analyzing-Information-Using-Graph-Build...

 

Q: In a presentation, can you link a chain of graphs and click to show without going through several steps in JMP. Just like autoplay?

A: JMP doesn’t currently do this.  You can post the suggestion to the JMP Wishlist.

 

Q: Can hover graphs on one Graph come from separate, open tables?

A: No. You would have to combine the data into one table.

 

Q: When the graph is saved in PowerPoint, will all the drill-down plots be saved there too?

A: No, PowerPoint doesn’t support that level of interactivity.

 

Lovy_Singh_1-1695230316556.jpeg

 

 

Lovy_Singh_2-1695230316557.jpeg

Using Column Order to determine what goes on drill-down graph

Lovy_Singh_3-1695230316558.jpeg

Next in Hierarchy Column Property

Lovy_Singh_4-1695230316558.jpeg

Save Script to Clipboard to start nesting graphlet Hover Label code

Lovy_Singh_5-1695230316558.jpeg

Paste Graphlet Code to Build Hover Label Code for Graph

Resources

Comments
hogi

Very good tutorial on Hover graphs. Thanks a lot!

actually, there is a way to use   Hover graphlet from another data table 

Recommended Articles