cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar

Using Formulas to Get the Most from Your Data

Published on ‎11-07-2024 03:28 PM by Community Manager Community Manager | Updated on ‎11-07-2024 05:38 PM

 

See how to:

  • Develop familiarity with foundational column formula concepts
    • Expression that dynamically computes values stored in a column, often based on other columns' values
    • Part of Column Properties
    • Specified in Column, not in each cell
  • Understand sequence for creating formulas
    • Standard formulas available: Right click >New Formula
    • Formula Editor (calculator) available for building custom formulas
    • Specify formula in formula box where you can create w/ point-and-click or double-click to type manually
    • Blue highlight shows selection scope
    • Column List shows available columns and red triangle lets you filter
    • Keypad gives common mathematical operations and formula editing actions
    • Function List groups functions by type and is browsable, searchable, customizable
  • ·Envision how you can use column formulas with your data – what formulas can help you do – using Population Data Case Study

 

Note: Q&A is included at times 24:07, 24:41, 43:06, 43:49, 44:18 and 44:40.

 

Resources:

 

 

See how to:

  • Create formulas interactively without using Formula Editor
  • Use the Formula Editor, hover help, common numeric and character functions, and interactive formula function filters
  • Use a combination of JSL and Add-Ins to extend JMP formula functionality 
  • Use formulas in a case study of fluid levels measured at one minute intervals where the goal is to automatically determine the vessel state (filling, emptying, or holding) at any given time
  • Change formulas and see auto recompute
  • Use local and table variables in formulas

 

Resources 



Start:
Mon, Aug 17, 2020 02:00 PM EDT
End:
Mon, Aug 17, 2020 03:00 PM EDT
Labels (1)
Attachments
0 Kudos
0 Comments