# Lets get the group together to share highlights and discoveries from the Discovery Summit

Last week at the Discovery conference I learned a ton of new tips and tricks for working with data and I'm pretty sure I'm not the only one!

Where & When:Tuesday Oct 11, at the SAS campus in Cary NC. Building F (training building, Google Maps).

5:30 - 6:00 Networking and Snacks

6:00 - 7:30 Meeting

Cost: Free

Who: Any JMPer, whether you went to the Discovery Summit or not.

Agenda:

1. Discovery Summit Highlights

-Analysis insights

-Formulas and JSL

-Hot talks and posters

JMP Systems Engineer, Pharm and BioPharm Sciences

# Meeting Notes

## 1. Discovery 2016 recorded presentations:

Lots of the talks were recorded and the slide decks, journals and example tables are attached to the talk pages.

This is super helpful if you weren't able to attend more than one talk at a time during Discovery, or if you wanted to catch up on the latest.

## 2. Handling specification limits in column formulas

Jerry Cooper presented a really unique method of using spec limit properties in a column formula

His talk is here:  Letting Go of Excel: Hello Formula Editor

In the link, you can download his data table. The two interesting formulas are in these columns

### :height.is

Names Default To Here( 1 );

specs = :height << getproperty( "Spec Limits" );

isResult = Function( {x, y},

:height << Color Cells( x, Row() );

y;

);

If(

:height > specs["USL"], isResult( 3, 1 ),

:height < specs["LSL"], isResult( 5, -1 ),

specs["LSL"] <= :height <= specs["USL"], isResult( 4, 0 )

);

The big Ah-Ha is the getting the spec limit property in the formula.

### :height.is.LocSorted

{"Too Short", "Just Right", "Too Tall"}[Loc Sorted( [0, 64, 68.1], :height )]

Here, getting the values in a matrix and then using that sorting to produce labels. Its easier than a conditional match.

## 3. Control Chart Builder

Event Chooser is a new option for Attribute charts. This is very very handy.

Annie Dudley Zangi's talk is here Control Chart Builder Can Do That?

## 4. Creating Dynamic Workflows

Brady Brady, hits the ball out of the park with completely unglued new utility that he presented in his talk

If there was only one thing you had to take away and try from all the talks at Discovery, this is #1. (IMHO)

Here's what you do.