Choose Language Hide Translation Bar

Pictures from the Gallery 8: Innovative Graph Builder Views - (2023-US-30MP-1386)

A picture is said to be worth a thousand words, and the visuals that can be created in JMP Graph Builder can be considered fine works of art in their ability to convey compelling information to the viewer. This journal presentation features how to build popular and captivating graph views using JMP Graph Builder. Based on the popular Pictures from the Gallery journals, the Gallery 8 presentation highlights new views and tricks available in the latest versions of JMP. We feature several popular industry graph formats that you may not have known could be easily built within JMP. Views such as integrated tabular graphs, satellite mapping, formula-based graphs and more are also included, helping you breathe new life into your graphs and reports!

 

 

All  right . Welcome ,  everybody .

My  name  is  Scott  Wise ,

and  we  are  going  to  talk about  pictures  from  the  Gallery  8 .

Every  year  we  come  up  with  some fantastic  views  that  you  can  do  in  JMP

that  you  might  not  have  known

because  there  are  some  tips and  tricks  involved .

We  definitely  are  excited to  show  you  our  next  release .

Before  we  begin ,

I  always  like  to  start  off with  something  interactive  here .

I  got  inspired  by  a  recent  trip I  took  with  my  daughter .

We  went  to  the  National  Video  Game  Museum .

It 's  up  in  Dallas ,  Texas ,

and  it  walked  through the  development  of  video  games .

They  had  a  game that  I  used  to  love  to  play .

It  was  called  Battle  Zone .

You  kind  of  felt  like you 're  on  this  strange  planet ,

everything  was  in  3D and  you  felt  like  you 're  inside  a  tank .

It  was  really  cool .

To  make  this  game ,  they  had  to  overcome a  big  problem  with  graphics ,

which  is ,  if  you  have  3D  graphics ,

how  do  you  know  where  you  are in  relation  to  an  object ?

If  there 's  a  wall  in  front  of  you

or  are  you  in  the  wall   or  are  you  in  the  back  of  the  wall ?

Are  you  in  front  of  the  wall ?

It 's  obviously  something  they 've  overcome

because  a  lot  of  the  games now  are  3D  and  first -person

and  so  give  you  that  perspective .

Well ,  actually ,  I  can  represent this  problem  in  Graph  Builder

and  I 'm  going  to  challenge  you

and  maybe  if  you  learn  this  trick on  how  they  solve  this  problem ,

it  can  help  you  maybe  win  a  bet sometime  down  the  road  here .

Or  you  can  challenge  people  for  fun .

What  I 'm  going  to  do is  I 'm  going  to  show  you  a  basic  shape

and  there 's  going  to  be  two  points , a  point  A ,  a  point  B ,

I  want  to  know  if  point  A  is  inside or  outside  that  shape .

If  point  B  is  inside or  outside  that  shape ,

and  you  are  going to  have  just  three  seconds .

So  maybe  grab a  little  scrap  piece  of  paper

and  a  pencil  so  you  can  write  this  down .

I 'm  going  to  only  leave  it  up for  three  seconds .

The  first  shape  is  going  to  be  a  polygon .

All  right .

Again ,  I 'm  going  to  show  this  to  you .

I 'm  going  to  count  to  three ,

and  you  tell  me  if  point  A is  inside  or  outside  the  shape

or  if  point  B  is  inside or  outside  the  shape .

All  right . Are  you  ready ?

All  right ,  here  we  go .

All  right . Well ,  what  do  you  think ?

Was  A  inside  the  shape  or  outside ?

What  about  B ?

Let 's  pull  t`his  back  up .

Now  I  guarantee  probably   everybody  got  this  in  three  seconds .

A  really  looks  like  it 's  inside this  little  U -shape  to  me .

We  can  click  into  shapes  in  JMP we  can  color  the  background  of  shapes ,

and  that  makes  it  just  really  easy . So  A  is  inside  and  B  is  outside .

Okay . I  think  you  got  this  down .

Well ,  what  if  we  make this  a  little  more  challenging ?

I  have  another  shape .

In  this  shape , it  seems  it 's  going  to  be  a  polygon .

I  think  it  looks  like  a  spiral .

I 'm  going  to  do  the  same  thing .

We  got  point  A ,  point  B .

Tell  me  if  it 's  inside  the  shape of  the  spiral  or  outside .

Same  thing  with  point  B . All  right .

Ready ?  I 'm  going  to  going  to  launch  it and  I 'm  going  to  give  you  three  seconds .

All  right . What  do  you  think ?

Is  point  A  inside  the  shape  or  outside ?

What  about  point  B ?

All  right . Probably  didn 't  have  enough  time .

Maybe  some  of  you were  trying  to  use  your  fingers

and  maybe  trace  the  shape .

Three  seconds is  not  enough  time  to  do  that .

Now ,  again ,  within  JMP because  we  can  click  on  points ,

I  can  click  on  this  point and  I  can  see  that  point  A  is  inside

and  point  B  is  outside  of  the  shape .

But  that 's  not  the  easiest  way  to  do  this .

From  a  computer  programing  standpoint , they  needed  a  better  way .

There  is  a  method  actually  out  there that 's  actually  going  to  help  us  do  this ,

and  it  is  called  Ray  Casting .

It 's  pretty  simple . It  just  involves

From  whatever  point  you  care  about , you  just  draw  a  line  moving  away

in  any  direction  from  the  point and  you  count  the  number  of  lines

in  the  shape  it  intersects , walls  of  the  shape  so  to  say .

If  it  crosses  an  odd  count  of  lines  as  it 's  moving  outside  the  shape ,

it 's  in .

If  it  crosses  an  even  count  of  lines , it 's  outside .

All  right .  Well ,  let 's  see how  that  works  in  practice .

Here 's  the  U -shape .

All  we  got  to  do  is  just  draw  a  line and  see  how  many  times  it  intersects .

I 've  done  this  in  JMP .

I 'm  going  to  show  you  a  little  later  how you  can  draw  these  confidence  intervals ,

raise  these  lines out  of  points  within  JMP .

But  I 'll  go  ahead  and  open  one  up  here .

Let 's  take  a  look  at  point  A .

There 's  point  A .

Let 's  go  ahead and  see  how  many  points  it  has

before  it  exits  the  total  shape  here .

There 's  a  one , there 's  a  two ,  there 's  a  three .

There  were  three  walls it  crossed  before  it  went  out .

That 's  odd  so  it 's  in .

This  is  one  of  the  few  places , if  you 're  odd ,  you 're  in .

You 're  in  the  shape  if  you 're  odd .

But  what  about  B ?

Well ,  it  doesn 't  matter  which  way  you  go  with  B ,

let 's  go  in  this  direction, it  hits  that  wall,

it hits that  wall ,  it 's  even .

If  it 's  even ,  it 's  out .

It  works  whether  you  go  left  or  right .

Very  cool . Well ,  what  about

That 's  okay . But  you  could  have  eyeballed  that  one .

What  about  that  nasty  spiral  shape ?

Well ,  let 's  take  a  look  at  it . Let 's  go  ahead  and  take  B .

I 'll  come  down  here  to  B .

Let 's  just  go  this  direction .

One  wall ,  two  wall ,  that 's  even .

Let 's  take  A .

Way  down  here  at  the  bottom . All  right .

Let 's  see . One  wall ,  two  wall ,  three  wall ,  four  wall .

1 ,  2 ,  3 . I  missed  one ,  five  walls .

Five  walls  it  goes  by .

So  it 's  odd   and  therefore ,  it 's  in  the  shape .

That 's  how  it  works .

Basically ,  this  algorithm  drives all  those  3D  video  games

and  all  those  3D  images  that  you  see and  just  a  really  cool  thing  you  can  do .

I 'm  going  to  talk  a  little  bit about  drawing  these  lines  in  a  graph

in  our  pictures  from  the  gallery .

But  I  thought  that was  a  fun  interactive  example

to  get  us  started  with  our  talk  today

and  maybe  give  you  something you  can  amaze  your  friends  with .

All  right .  Let 's  talk  about the  pictures  from  the  gallery .

We  show  six  advanced  views

that  either  we  challenged  ourselves to  come  up  with ,

our  customers  using  JMP  challenged   just  us  to  come  up  with ,

or  what  we  just  saw look  so  cool  and  we 're  like ,

how  do  we  do  this  in  JMP   and  Graph  Builder  can  do  about  anything .

In  this  case ,  we 're  going to  look  at  formula -based  graphs .

I  have  an  actual  formula  in  a  column .

Can  I  have  that  work  within  Graph  Builder ?

What  about  tabular  data ?

Can  actually  have  information lined  up  like  report ,  tab  data ,

lined  up  underneath  my  graphic  shapes ?

That  would  be  really  cool .

What  about  an  input -output  parallel  plot or  we 'll  call  that  a  flow  parallel  plot .

That  might  be  really  cool .

Forest  plots .

Forest  plots  help  you  look  at  means

and  confidence  intervals and  you  can  eyeball  control  them .

This  is  really  popular in  health  and  life  science .

We 're  going  to  look  at  that  one.

Percent of Factor . Everything  scales  to  100 %.

Nice  way  to  compare  things using  bars  that  go  from  0 -100 %.

You  can  see  what  segments here  account  for  what .

Last  but  not  least ,

mapping  and  this  is  doing satellite  drill  down  something  you  can  do .

The  things  I 'm  going  to  show  you, this  Mapbox  mapping  in  the  tabular  data ,

these  are  actually  new  features  in  JMP  17 .

The  others  could  be  done with  older  versions  of  JMP ,

but  we  definitely  want to  feature  a  couple  new  things

that  have  come  out in  the  latest  release  of  JMP .

All  right .  I 'm  going  to  give  you this  journal ,  that 's  the  reward

for  attending  this  talk .

When  you  get  this  journal ,  it 's  going to  have  all  the  information  you  need .

It 's  going  to  have  a  picture of  what  we 're  trying  to  replicate .

Why  it 's  good ,  tips .

It 's  going  to  give  you  the  raw  steps on  how  to  create  these .

You  will  also  include  the  data with  the  scripts  to  recreate  it  here .

All  right .  This  first  one  is  actually bringing  in  a  formula  into  JMP ,

which  is  really  cool .

There 's  tips  to  do  this .

The  tip  is  you  must  have  a  formula  column  within  your  data  table  and  JMP .

That  makes  sense .

But  you  need  to  find  a  way  to  include all  the  elements  of  the  formula .

If  you  have  an  X  and  a  Y  in  your  formula ,

the  X  and  Y  need  to  be  somewhere in  one  of  the  landing  zones

within  the  Graph  Builder .

A  better  way  to  put  it .

All  right .

You  have  those  steps  if  you  need  them .

I 'm  going  to  do  this  one  just  from  the  data  in  the  journal .

Let 's  see  what  we  have  here .

This  was  real  data  that  my  father asked  me  to  help  him  with .

He  was  actually  trying  to  decide on  buying  a  garden  hose .

He  was  doing  a  lot  of  washing  of  his  patio and  his  siding  at  his  house ,

and  he  wanted  to  make  sure that  he  had  the  best  water  flow .

Well ,  there  is  a  formula  for  water  flow , and  here  is  that  formula .

It  matters ,  the  diameter  of  your  hose .

You  have  a  three -fourths -inch  diameter , a  half -inch  diameter .

It  matters  how  long  the  hose  is .

I  guess  the  distance  between  the  spigot  and  the  spray  attachment

or  the  end  of  the  hose .

That  worries  what  kind of  water  pressure  you  have

coming  out  of  your  initial  spigot .

You  have  40  pounds ,  60  pounds ,  so  on .

There 's  a  formula  in  here

and  easy  to  create  formulas using  JMP 's  formula  editor

I  have  other  information . I 'll  turn  on  these  little  header  graphs .

It  looks  like  I  have  from  0 .75 ,  the  0 .5 even  have  a  0 .625  hose  diameter .

Looks  like  I  got  40 ,  50 ,  and  60  water  pressures

running  through  that  formula

and  it  looks  like  we  collected  data  for ,

looks  like  from  25 -50 to  75 -100  hose  lengths .

So  the  100  feet .

All  right . I  have  all  this  information .

Let 's  just  go  to  Graph  Builder and  let 's  start  to  fill  it  out .

Here  are  all  my  landing  zones .

I 'm  going  to  take  the  one  that has  the  formula  in  it  and  put  it  in  first .

That 's  the  water  flow .

I  put  it  in  the  Y  here .

I  think  I 'll  put  the  length down  here  on  the  X .

Looking  a  little  more  interesting .

Maybe  diameter  would  be a  good  thing  to  overlay  by .

I  overlay  and  so  you  can  see I  get  three  different  lines  there

for  the  hose  diameter .

I  knew  the  water  pressure

and  he  was  probably  going  to  go to  the  water  pressure  he  had .

I 'm  going  to  put  that  on  the  Group  X instead  of  having  three  panels  here ,

I 'm  going  to  right -click and  I 'm  going  to  go  Level  in  View

and  I 'm  going  to  go , let 's  just  do  one  at  a  time .

Now  we   can  flip through  these  and  see  them .

Okay ,  now How  to  represent  this .

It 's  okay  to  have  points , but  this  smoother  line  is  not  the  formula .

It 's  just  doing  some  sort of  spline  smoother  through  here .

That 's  not  really  helping  me .

What  about  if  I  select , I  don 't  know ,  a  straight  line ?

Well ,  that 's  not  really  reflecting . That 's  just  connecting  the  points .

That 's  not  reflecting  the  formula .

To  do  the  formula ,  I  can  select this  little  formula  icon  here ,

or  you  can  even  right -click in  here  and  just  go ,

hey ,  line ,  change  that  out  to  formula .

Now ,  it  is  reading  the  formula .

It  will  not  work  unless  all the  elements  of  the  formula  are  there .

See  if  I  take  this  overlay  diameter  out , you  see  the  line  disappears .

It 's  got  to  have  all  the  elements of  the  formula  somewhere

accounted  for  in  a  graph  element .

But  now  it 's  pretty  cool .

Now  I  can  sit  there  and  see  that , oh ,  looks  like  high  diameter ,  0 .75 .

The  shorter  the  hose  length ,

the  higher  the  water  flow is  going  to  be  at  40 .

It  looks  like  it 's  holding  for  50  or  60 .

Something  you 're  going to  see  me  do  a  lot  as  well  is

I 'm  going  to  show  you how  you  get  that  little  picture  in  here .

It 's  easy  if  you  have  a  picture just  like  a  jpeg .

It 's  easy  just  to  drag  it right  into  your  graph .

Now  I  have  it  dragged .

If  you  right -click  into  the  graph , there 's  a  section  for  images

and  you  can  size  it . I  usually  use  this  fill  graph .

Then  you  can  right -click  again and  you  can  even  make  it  transparent .

I  like  to  do  that  so  I  can  see  the  points , maybe  make  it  only  a  40 %  clear ,

so  I  can  see  the  lines popping  through  there .

Now  that 's  a  cool  graph and  that 's  how  you  do  this  view .

Now  we  can  go  and  pick the  right  size  hose  that  we  want  to  use

no  matter  the  water  pressure  we  have .

All  right .

Again ,  you  have  that available  to  you  at  any  time .

Remember ,  I  have  the  scripts saved  to  the  data .

You  can  click  on  it and  you  can  recreate  it  at  any  given  time .

All  right . That 's  the  first  one .

We 'll  go  through as  many  as  we  have  time  for .

I  think  we 'll  get  through  all  six  today .

I  have  them  ordered  in  terms of  when  I 've  shown  this  before

and  what 's  the  most  popular.

The  next  most  popular  one is  this  tabular  data .

This  is  something  that became  available  in  JMP  17 .

Why  this  is  nice  is

It  used  to  be  when   I  made  a  nice  graph  here ,

I 've  got  box  plots  up  in  this  area .

It  used  to  be  I  had  to  go and  create  in  a  separate  window ,

maybe  something from  Tabulate  to  create  a  table

and  just  had  to  line  those  two different  graph  windows  up .

But  what  if  I  wanted  it  right  underneath ?

Well ,  we  now  have  that  capability

and  it 's  going  to  be  actually using  new  features  and  caption  boxes

that  are  in  JMP  17 and  it 's  going  to  help  us  with  tables .

It 's  even  going  to  help  us with  recalculating  reference  lines .

Well ,  that 's  cool . What  does  that  look  like ?

All  right .  I  have  this  data  set  here .

It 's  cool  when  it 's  got all  this  chemical  production .

I  got  this  rate  of  reaction and  I  have  these  different  vendors .

Say  I 'm  just  really  interested

in  graphically  seeing a  difference  in  the  vendors

by  the  rate  of  reaction  here .

Put  that  on  the  Y , vendor  on  the  X .

Maybe  points .

It 's  not  as  interesting as  maybe  a  box  plot .

Maybe  I 'll  color  by  rate  of  reaction .

Maybe  I  will  come  up in  this  little  bottom  left -hand  side ,

we  call  this  the  panel  boxes  here

and  I  can  go  under  this  box  pop -panel and  I  say ,  give  me  a  confidence  diamond .

That 's  pretty  cool .

I  know  the  middle . That  diamond  is  where  my  mean  is .

What  if  I  make  this  even a  little  more  interesting ?

You  can  hold  your  control  key  down , shift  key  down

if  you 're  using  a  Mac  like  I  am , I 'm  going  to  put  this, I  click .

I  got  points  on  top  of  the  box  plots .

I 'm  going  to  come  down  to  where this  point  is  and  say  summary  statistic ,

I  don 't  want  to  see  them  all . Just  show  me  the  mean .

Yes ,  the  point  is ,  in  the  middle of  the  diamond ,  that  makes  sense .

Oh ,  I  can  even  help  it  a  little  bit .

I 'm  going  to  do this  air  interval  selection .

I 'm  going  to  do a  confidence  interval .

Now  I  can  see  the  ends  of  the  diamond .

Oh ,  that 's  really  cool .

Maybe  I  want  to  shade  it  all  in

and  there 's  an  interval -style  here called  Hash  Band  I  like .

Now  it 's  all  instead  of  those  lines , just  those  little  whisker  lines ,

now  I  have  this  little  shaded -in  square  and  that 's  pretty  cool .

That 's  telling  me  maybe Acme  has  a  lower  rate  of  reaction

than  somebody  like  Green .

Acme  is  over  here , bluish ,  green  is  higher  and  reddish ,

although ,  the  box  plot 's  showing  me ,

there 's  a  lot  of  data  in  between , a  lot  of  spread  of  the  data .

There 's  a  lot  of  variation  here .

But  what  if  I  want  to  now bring  in  what  is  the  mean ?

Not  only  what  is  the  mean for  the  rate  of  reaction  overall ,

but  what  is  the  mean for  Acme ,  Bloom ,  Green ,  and  this  Rizen ?

How  can  I  do  that ?

What  I 'm  going  to  do is  I 'm  just  going  to  right  click  in  here

and  I 'm  going  to  add  a  caption  box and  you 're  like ,  Scott ,  that 's  boring .

I  knew  how  to  do  that  in  JMP  16 . It 's  just  sitting  right  up  top  of  here .

Yes ,  but  there 's  a  new  thing you  can  do  with  caption  boxes .

There 's  a  location  area  here .

For  the  mean ,  I  can  actually  say ,

you  know  what ,   make  it  an  axis  reference  line .

Now ,  it  is  right  here  in  my  data .

That 's  really  cool .

What 's  really  cool  about  this,

and I 'm  going  to  right -click  over  here , I 'm  going  to  turn  on ...

I 'm  going  to  go  under  redo .

You  might  have  seen column  switchers  before

and  say ,  I  want  to  switch  out  the  rate of  reaction  with  some

of  the  other  type of  continuous  factors  here

and  now  get  my  little selection  box  over  here .

I 'm  clicking  on  agitation .

Do  you  see  it  recalculates the  mean  for  agitation

and  here 's  the  mean  for  inlet ?

This  is  much  better  than  right -clicking and  go  in  under  axis  settings

and  setting  a  static  reference  line because  that  won 't  change .

But  this  will  change  if  the  axis  change if  what  you 're  calculated  from  changes .

That 's  pretty  cool , let 's  leave  it  at  rate  of  reaction

and  let 's  go  ahead and  let 's  do  one  more  thing .

I 'm  going  to  add a  second  caption  box .

I  right -click  in  here , I 'm  going  to  go  add

and  you  can  add  two  or  more , one  or  more  elements .

Now  I  add  a  second  caption  box .

This  first  one  is  doing an  axis  reference  line .

It  doesn 't  know  what  to  do with  the  second  one .

It  has  it  overlaying  on  top of  the  other  caption  box .

Then  I  can  just  say ,  you  know  what ? This  one  make  it  into  an  axis  table .

You  see  now ,  oh ,  it 's  lined  up right  underneath  all  the  labels

and  underneath  all  the  columns ,  so  to  say , for  all  my  categorical  levels  here .

I  can  even  add  another  summary  statistic and  I  can  go  and  do  like  standard  error

and  I  can  just  keep  adding  more and  now  I  can  build  out  a  nice  table ,

I  can  say  done  here .

All  I  really  would  have  to  do  now is  maybe  just

go  under  the  Graph  Builder  red  triangle and  clean  up  the  legend  here .

I  can  go  to  the  settings  here and  I  don 't  need  all  these  little  legends .

I  can  just  keep  the  one for  the  color  gradient

and  down  here  as  well .

If  you  want  to  get back  to  that  control  panel .

You  say  so ,  control  panel .

There  was  one  more  thing I  was  going  to  show  you  here .

You  see ,  I 'm  carrying four  decimal  points  down  here .

The  caption  box will  let  you  change  the  format

and  I  can  do  like  fixed  decimal  two .

Now  that  looks  really  nice .

Even  to  make  it  even  nicer , I  found  out  this  is  a  nice  little  trick .

I  found  out  you  can  change the  legend  position .

I  can  put  it  at  the  bottom .

If  I  right -click  in  here and  go  to  the  gradient ,

you  can  even  make  it  horizontal .

I  love  this  kind  of  horizontal  views and  now  it 's  a  much  more  compact  view

and  it 's  going  to  look  a  lot  better when  I  start  to  change  things  around .

All  right . A  very  cool  graph .

I  would  like  to  give  some  thanks  as  well to  Joseph  Reese ,  one  of  my  peers

who  helped  me  create  this  chart and  figure  it  out .

Thank  you ,  Joseph .

All  right .

What  are  we  going  to  look  at  next ?

The  in  and  out  parallel  plots .

This  one  here .

It 's   cool  because  I  often  did  work where  I  had  like  a  project  budget

and  you  had  so  much  money that  would  go  into  the  total  budget

and  then  you 're  pulling  out to  make  expenditures

or  you  have  inputs and  outputs  of  a  process .

I  used  to  do  a  lot of  input -output  boxes .

Well ,  this  is  a  parallel  plot which  is  showing  me

with  the  size and  the  width  of  these  bands .

How  much ,  in  this  case  money is  coming  from  jobs  here .

But  it 's  all  going into  one  big  bucket  here

and  then  out  of  that  bucket , I  have  outflows .

That 's  really  cool . How  do  we  set  this  up ?

We 're  going  to  do  something

that  enables  us  to  actually  look at  combine  data  in  a  parallel  plot .

It 'll  be  a  little  easier to  show  you  by  hand .

Here  is  my  data .

Now  setup  is  everything  on  this and  every  row  here  is  an  expenditure .

You  see , I  have  a  separate  amount  for  that .

But  sometimes  those  expenditures get  rolled  up  into  groupings .

Like  here ,  I 've  got  a  lot of  these  are  going  into  job ,

so  I  have  a  column  for  inflow and  I 'm  putting  the  category  for  inflow

and  I  have  a  lot  that ...

All  these  line  items of  inputs  go  in  to  job .

That 's   cool . I  got  tax  refund .

I 've  got  side  hustle  here .

There 's  the  total  bucket and  you  can  see  I  can  start  with  outflows .

Here ,  I  can  look  at  all  the  savings  here and  I  have  20K  versus  savings  here

and  you  can  see  I  can  even  have  a  second outflow ,  which  breaks  that  savings  down

to  where  what  type  of  savings  it  went  to .

Some went  to  401K, some  went to  investment .

If  you  have  things  set  up  like  this

now ,  I  have  everything I  need  to  make  this  chart .

I 'm  going  to  go  to  Graph  Builder .

Border .

I 'm  going  to  just  take all  the  categorical  factors

and  I 'm  just  going to  dump  them  on  the  x -axis .

I  might  color  by  the  outflow  one and  I 'm  going  to  size  by  the  amount .

Now  it's  stuck  on  point so  I will  change  to  parallel  plot .

I 'll  make  this  a  little  bigger .

Now ,  if  I  put  the  control  chart  down , it 's  looking  okay .

But  what  it 's  doing  now ,

it 's  taking  my  inflow  boxes and  then  it 's  slowly  breaking  them  out .

Why  only  want  the  breakout  to  happen  here ?

I  want  to  see  what  comes  in from  the  outflow

and  what  goes  out  from  that  section .

To  do  that , if  it 's  in  the  second  section ,

if  I  click  on  this  combined  data  sets , it  restarts  on  the  second  bar ,

so  to  say ,  of  the  parallel  plots .

If  I  say  done , you  can  play  with ,  which  is ,

whether  things  are  ascending or  descending

with  clicking  on  these  arrows  up  here , I 'm  going  to  click  on  a  few  of  these .

Now  it 's  very  easy  for  me  to  see how  jobs,  side  hustle

and  tax  refund  make  up  my  total of  101K

and  now  I  can  see  something  like  auto and  that 's  very  cool .

You  can  see  here  my  auto  was  11K and my  total ,  101K

and  I  can  see  if  I  make this  even  a  little  bigger ,

I  can  see  that  it  gets  broken  out  among my  car  payment ,  my  gas  and  my  upkeep .

This  is  just  a  really  cool  chart  to  use

and  there 's  other  things  you  can  do to  make  it ,  enhance  it  a  little  bit  more .

You  can  play  with  the  colors ,  but  a  really cool  inflow -outflow  parallel  plot .

All  right . See  how  we 're  doing  on  time ?

We 're  doing  pretty  good .

Let 's  move  on  to the  next  most  popular  views  here

in  our  pictures  from  the  gallery .

This  one 's  going  to  be  a  forest  plot .

Forest  plots  are  going  to  enable  you to  like  plot  means

and  put  a  confidence  interval  around the  mean  that  you  can  compare  to  other

means  with  confidence  intervals on  the  same  chart .

It 's  very  popular , especially  in  health  and  life  science

place  where  you 're  doing  a  lot of  summarization .

But  we  have  a  cool  little  example here  on  how  to  do  forest  plots .

Here  it  is .

We  are  going  to  go  out and  we  are  going  to  buy  a  diamond .

Maybe  you 're  getting  engaged . Maybe  you 're  getting  married  here .

Now ,  people  always  talk about  that  cut  color  and  clarity

and  there 's  all  these other  little  different  levels  within  them .

Do  they  really  matter ?

What  really  drives  what  you  care  about ,

which  is  what 's  the  average price  for  this ?

How  much  am  I  going  to  have to  pay  for  a  diamond ?

I  want  to  impress whoever  I 'm  getting  engaged  or  marry .

But  want  to  do  it as  efficiently  as  possible .

Let 's  take  care  of  this . Let 's  go  ahead  to  our  diamonds '  data .

Let 's  take  a  look .

I 'm  going  to  open  up the  column  headers  here .

It  all  comes  from  one  table that 's  not  that  interesting .

But  you  see ,  I  have  summarized .

Each  row  is  summarizing  the  mean and  the  standard ,

the  mean  and  the  lower  and  upper confidence  interval ,  the  standard  error .

Just  some  summarized  metrics here  for  it  looks  like  a  combination

of  color ,  a  color  in  level  here .

I 've  got  color ,  levels ,  I 've  got  clarity , I 've  got  cut

and  just  all  kinds of  levels  within  there  that  I  want .

To  look  at  this  data ,

I 'll  just  go  ahead and  put  the  Graph  Builder .

I 'll  put  my  mean  price  down  at  the  bottom .

Don 't  have  to  worry  about  the ...

I 'm  not  going  to  worry  yet  about  the confidence  interval  around  the  mean .

We 'll  do  that  last .

But  let 's  go  ahead  and  put  the  X  here . There 's  my  color  clarity .

I 'm  even  going  to  color  by  the  x .

I 've  got  points automatically  being  driven ,  that 's  fine .

Now  level ,  I 've  got  the  different  levels of  cut ,  clarity  and  color .

Yeah ,  I 'm  going  to  move  it  here . But  you  see ,  you  can  embed  in  here .

I  have  the  level  nested  within  my  x , which  was  the  cut  color  of  clarity .

That 's  pretty  cool .

Maybe  to  make  it  easier  to  segregate those  three  different  aspects ,

I 'm  going  to  right -click  here , I 'm  going  to  go  to  the  axis  settings

and  I 'm  going  to  reverse  the  order .

I 've  got  clarity  first and  under  the  X  tab  up  here ,

I 'm  going  to  show  a  grid that 's  going  to  draw  lines  there .

Now  I 'm  looking  over  three  sections .

This  is  okay , but  I  hate  the  eyeball  these  points .

What  can  I  do ? Let 's  take  this  lower  95

and  upper  side  percent confidence  interval

and  let 's  bring  it to  that  interval  landing  zone .

You  see  what  it  has  done is  it  is  created  error  bars

constructed  around  that  lower  95 and  upper  side

95 %  confidence  interval  around  the  mean .

If  you 've  got  a  column  form , you  can  bring  them  into  that  landing  zone .

You  can  even  bring  in  a  one -sided  one if  you  only  have  an  upper  or  lower .

But  I  like  this  kind  of  shows me  where  those  points  are .

You  can  right -click  in  here and  you  can  mess  with  the  marker  sizes

and  you  can  make the  marker  sizes  all  big

or  I 'm  going  to  make  them a  marker  size  a  five .

Now ,  if  I  look  at  it now ,  I  can  answer  some  good  questions

about  what  I  should  look  for  in  a  diamond .

What 's  really  driving  the  price ?

Remember  the  further  it 's  going  on  x -axis the  more  expensive  the  diamond  is .

If  I  look  at  clarity , this  does  not  make  sense

because  some  of  my  clearest these  things  this  IF

it 's  almost  like  flawless  clarity

or  very, very, very  subtle differences  in  it .

This  is  actually  costing  less  than the  stuff  that 's  supposed  to  be  a  better .

That  one  makes  no  sense .

What  about  color ?

D  was  supposed  to  be  the  best . K  was  supposed  to  be  the  worst.

But  I 'm  seeing there 's  two  groups  over  here .

What 's  really  driving  it ?

It  looks  like  it 's  cut  and  the  ideal cuts  are  the  most  expensive  ones .

Then  excellent and  very  good ,  then  good .

You 're  going  to  go  buy  the  diamond ,

forget  about  the  color  rating , forget  about  the  clarity  rating ,

really  focus  on  the  cuts and  that 's  what 's  going  to  drive  price .

All  right . Very  cool  to  do  that  type  of  graph .

That 's  a  forest  plots . Very  easy  to  do  in  JMP .

All  right . What  is  our  next  view ?

Our  next  view  is  actually  something  cool . It 's  good  to  do  with  ranked  or  scale  data .

It 's  percent  of  factor .

This  is  something  most  people didn 't  know  we  had  the  capability

to  do  in  Graph  Builder .

We 're  going  to  look at  some  coffee  shops .

I  have  all  this  data  from  my  hometown  here

where  I  live  is  in  Austin ,  Texas , and  I  got  all  these  coffee  shops

and  it  looks  like  there  were  reviews and  they  gave  them  ratings .

Whether  the  ratings  low  or  high , 4  or  5  stars ,  the  best .

I  even  have  things  like  sentiment , like  how ,  what 's  the  vibe  of  the  place ?

That 's  something my  daughter  likes  to  say .

This  place  has  good  vibes  or  bad  vibes .

One  of  our  favorite  things is  checking  out  coffee  shops .

Where  should  we  go  this  afternoon ? We  want  to  get  some  coffee  around  Austin .

What  we 're  going  to  do is  we 're  going  to  set  this  up .

I 'm  going  to  go  over  here to  my  Graph  Builder .

I 'm  just  going  to  put my  coffee  shop  name  in  here .

Okay ,  that 's  pretty  cool .

Now ,  what  I  can  do , I  can  put  some  type  of  scale  here .

I  have  the  rating .

I  can  put  the  rating  down  here at  the  bottom ,

instead  of  points , I  can  ask  for  bars  to  be  done .

That 's  not  too  interesting this  side  by  side ,  but  I  can  do

a  percent  of  total .

I  think  I  have  this ...

Think  I  don 't  have  this set  up  correctly  here .

This  is  a  good  thing  you  do when  you  got  everything  saved  for ,  yeah .

I  can  come  right  back  in  here so  have  coffee  shop  name

and  I  have  counts so  I  had  the  wrong  thing  on  there .

You  want  something  continuous  on  there .

We  had  the  actual  count  of  the  data

instead ,  I  think  I 'm  going to  use  the  raw  numeric  rating

instead  of  the  one that 's  categorical  here .

Let 's  take  a  look  at  that  again .

Let 's  go  ahead and  put  my  coffee  shop  name  out  here .

Let 's  go  ahead  and  put  that  either that  rating  or  the  counts .

I  guess  I 'll  just  put  the  count up  here ,  down  at  the  bottom .

I 'll  go  to  bars  and  that 's more  what  I  was  looking  for .

Now  I  have  the  count -down  here . It 's  going  to  give  me  a  raw  count .

Doesn 't  look  that  interesting .

But  now  I  can  take that  categorical  rating ,

and  we  can  do  something  like overlay  by  it  and  take  a  look  at  it .

I 'm  going  to  go  back  and  double  check and  see  what  I  had  overlaid  by  here .

It  looks  like  overlaid  by  the  rating .

I  will  do  the  same  on  our  graph .

Now  take  that  rating , I  will  overlay  by  it .

It  looks  like  a  real  mess  right  now , but  now  I  can  go  in .

You  can  choose  different  types of  bars  here ,

but  the  one  I  am  going to  look  for  is  going  to  be  one

that  utilizes  a  new  summary statistic  called  percent  of  total .

I do  that  one,  percent of  total .

I  can  take  a  look  at  this in  different  types  of  bar  configurations .

Again ,  I  will  take  a  look  to  see  what  kind of  bar  configuration  I  had  used  here

in  my  finished  graph  and  I 'm  going  to  look at  stat  percent  of  factor

is  the  one  I 'm  going  to  do .

Instead  of  percent  of  total , let 's  do  percent  of  factor

and  now  let 's  do  the  stacked  one .

There  we  go . That 's  the  view  I  wanted .

Stacked  percent  of  factor .

It 's  going  to  change that  kind  of  count  to  100 %.

It  is  going  to  break  out  what  portion of  it  went  to  what  rating ,

which  is  really  cool .

Other  cool  things you  might  not  have  known  you  can  do .

I  can  right -click  in  here and  you  can  order  by  something .

I  can  even  order by  something  that 's  other .

Like  already  have  a  high  rating . Yes /no .

I  knew  this  was  like  fours and  fives  versus  one ,  twos  and  threes .

I 'm  going  to  select  that  one .

Now  you  can  see  it 's  kind  of  did a  nice  job  putting  the  ones

that  have  the  more  four  and  fives on  the  top  of  the  graph .

Now  I  can  say , "Hey ,  we  might  want  to  hit  the  Saa -Ten "

if  I 'm  saying  that  correctly .

This  is  my  favorite  coffee  house is  flight  path ,

so  maybe  we  weren 't  going  to  hit  that  one .

But  my  daughter  might  say , "What  about  the  vibe ?"

Then  you  can  say ,  "Well ,  that 's  good .

Let 's  just  do  a  little  local  data filter  and  let 's  bring  in  the  vibe ."

Maybe  make  this  a  block  style  view .

Now  let 's  go  and  select just  the  ones  that  were  two ,  threes

and  four  is  on  vibes  now , or  maybe  threes  and  fours  on  vibe

and  we 'll  do  two ,  threes .

I 'll  do  one two ,  threes  and  fours .

Now  we  can  see , "Oh  the  Hideout  has  really  good  vibes ."

Flight  path  still  down  here ,

but  maybe  we  want  to  go  and  check the  hideout  out  if  can  find  it .

That 's  the  easy  thing  you  can  do .

Why  I  really  like  using this  percent  of  factor .

If  you  can  have  a  continuous  x

and  you  can  even  overlay by  something  which  can  go  break

that  count  up  of  by  some  section , this  is  a  great  chart  to  use .

All  right .

That 's  just  going  to  leave us  with  our  last  chart .

Our  last  chart  is  probably the  most  photogenic  of  it .

It 's  going  to  be  Map box  Mapping .

This  is  something  new  in  17 that 's  really  powerful .

We  had  the  ability  to  look  up to  use  building  maps .

You  had  the  ability to  use  mapping  services  in  the  past .

But  in  17  we  came  up  with  a  much better  type  of  mapping  service ,

same  one  you  might  see  like with  Google  Maps  and  it 's  Mapbox  Mapping .

I 'm  going  to  look I  have  these  some  select  hotels

I  used  to  stay  at  when  I  used to  run  around  the  country  for  JMP .

I 've  I 've  got  all  kinds of  information ,  but  the  most  important ,

I 've  got  latitude  and  longitude in  the  hotel  name  and  the  counts .

This  will  be  a  good  thing  to  map .

I  know  I  can  go  in  the  graph and  Graph  Builder  and  bring  up  a  map .

I  know  I  can  put  my  latitude  down and  my  longitude  down

and  I  know  you 're  already  starting  to  see , the  shape  of  the  country ,

East  Coast ,  West  Coast  going  on  here .

I  know  I  can  right -click now  under  graph

and  go  to  that  background  map .

Now  instead  of  a  street  map  service or  just  doing  any  of  these  other  things

that  used  to  be  in  JMP , I  can  do  a  web  map  service

and  it 's  going  to  allow  me to  pick  from  all  these  Mapbox  options

and  like  Mapbox  dark  one is  pretty  cool .

That  we  can  select .

There  we  go .

You  do  it ,  and  I 'll  go  ahead and  I 'll  show  that  again .

It 's  under  background  map and  you 'll  select  a  street  map  service .

You  won 't  select  this  service unless  you  want  to  interact  with  it

by  specifying  a  layer , but  I don 't  worry  about  that .

Street  map  service  and  then you  pick  from  the  Mapbox  selections

and  this  is  what  a  dark  one  looks  like .

It 's  the  nighttime  view  of  the  country . That 's  cool .

I  saved  to  my  script  a  couple  of  others .

This  one  is  looking  at  the  Map box , outdoor  one .

So  if  you  want  to  see if  you 're  in  the  water ,

you  want  to  see  if  you 're  in  the  bay ,

you  want  to  see things  a  little  differently .

I  can  even  look  at  a  street  view . This  is  the  Map box  Street  View .

Now ,  to  do  this  one ,  I 'm  going  to

It 's  hard  to  see ,  but  you  do  have a  little  plus  or  minus  into  your  map

that  you  can  select  a  drill  down .

I  like  doing  it  through the  magnifying  element  up  here .

So  I  switch my  pointer  out  for  the  magnifier ,

and  here 's  a  hotel I  stayed  at  in  Sacramento .

I 'm  going  to  click  on  it .

I 'm  going  to  click  on  it . It  was  called  the  Delta  King .

What 's  up  with  this  one ?

It  looks  like  it 's  a  boat .

Well ,  I 'm  going  to  right -click  right  here .

I 'm  going  to  go  into  that  background  map

and  instead  of  Streets , I 'm  going  to  select  a  satellite .

How  cool . Now  I  can  go  see  it  is  a  boat .

The  Delta  King  is  a  very ,  very  cool ,

ferry  boat , a  historic  one  that  used  to  run  between ,

I  think ,  Sacramento  and  San  Francisco , and  they  made  a  hotel  out  of  it .

Now  you  can  stay  in  the  old  town in  Sacramento  and  check  it  out ,

thanks  to  Bonnie  Rigo .

When  I  work  with  my  team  right  now

who  introduced  me  to  this hotel  really  cool  one  to  use .

All  right .

That 's  how  we  do  these , and  I 've  got  other  cool  ones  in  here .

You  want  to  see

I 've  got  some  of  the  other  cool  places I 'd  stayed  here .

Like  looking  at  a  cool  one in  Las  Vegas  here .

Maybe  you  recognize  this  one ?

This  one 's  that  old  Luxor  pyramid .

That 's  why  silicon  in  Las  Vegas Satellite  views  are  really  cool .

We  even  looking  at  maps  of  Miami  Beach .

Cool  things  where  there 's  a  lot  of  water and  that 's  the  Fontainebleau

in  Miami  Beach .

Man ,  I  wish  it  was  one of  my  boats  as  well ,  but  it 's  not .

Very  cool .

Very  cool  things  you  can  do  now  in  JMP .

Graph  Builder  with  that  Mapbox .

All  right .

Let 's  go  and  take a  look  at  the  other  ones .

Again ,  thank  you .

Thank  you  to  Joseph  Reese for  helping  with  tabular  data .

I  don 't  think  I  mentioned

Jason  Wiggins  helped  me with  the  flow  parallel  plot .

So  thank  you ,  Jason ,  for  that  as  well ,

and  I  always  include in  my  journal  a  bonus  one .

I 'm  not  going  to  show you  how  to  make  this  one .

I 'm  going  to  give you  a  little  incentive  to  go  out ,

and  try  out  the  instructions .

They 're  there  for  you . This  is  a  painter  chart .

This  is  something  that  is  new in  the  Pareto  platform  in  JMP  17 ,

but  found  out  in  Graph  Builder ,

I  can  make  this  all  along .

It 's  a  combination  of  a  bar  chart , a  run  chart ,  and  Pareto  chart .

It  was  very  popular  at  places  like  Ford , when  they  were  looking  at  defects ,

and  I 've  seen  it  used  a  lot in  semiconductor  and  high -tech ,

for  example .

This  is  just  an  example of  how  to  create  this  type  of  combo  chart

within  a  Graph  Builder .

All  right ,  so  that 's  your  bonus .

I 'm  going  to  leave  you  behind with  where  to  learn  more .

I 'm  going  to  give  you  the  link  to  the other  seven  pictures  from  the  gallery .

Time  six , there 's  another  42  really  cool  views .

You  can  go  and  look at  an  additional  the  one  I  just  gave  you ,

and  that 's  on  our  JMP  community ,

our  source  for  everything  you  want , for  learning  JMP ,

for  past  discovery  talks , for  Q&A ,  for  whatever  you  need .

Blogs  and  journals ,

we 've  made  some  cool  blogs out  of  a  lot  of  these  graphs ,

so  please  visit those  as  well  on  the  community .

There  was  a  link  in  the  community  again

to  a  lot  of  the  good  training so  you  can  learn  from  our  the  godfather

of  the  of  the  Graph  Builder ,  Xan  Gregg .

Thanks  to  him for  creating  the  Graph  Builder

and  making  it  so  powerful , and  there  are  other  tutorials

and  training  available  to  you , as  well  as  the  presentations ,

and  if  you  have new  views  that  you  want  to  try  within  JMP ,

you  can  email  me , challenge  me  to  recreate  it .

Maybe  you  get  this  in  some  other  thing besides  JMP ,

or  you 've  done  it  in  a  spreadsheet , it  takes  a  long  time  to  make ,

and  you 're  like , "Can  I  just  do  this  in  Graph  Builder ?"

Challenge  us  and  if  we  have  something that  we 're  not  capable  of  making ,

but  would  be  good  to  consider for  future  releases  of  JMP ,

we  have  JMP  18 coming  out  pretty  soon  as  well .

We  would  love  to  hear  that  and  all  you have  to  do  is  go  to  the  community ,

go  to  the  JMP  wish  list ,

and  put  in  what  that  is , and  it  will  go  under  consideration

for  adding  into  possibly the  next  version  of  JMP .

All  right . That  is  my  talk .

Thank  you  so  much .

I  hope  you  enjoy  all the  talks  here  at  Discovery ,

and  please  let  us  know  next if  you  have  any  questions ,

and  have  fun  exploring  with  Graph  Builder .