cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar

Dif() and Lag() formula functions by column group (byVar argument)

Status: New Submitted by on ‎04-07-2023 10:58 AM
1 Comment (1 New)

Row functions are essential in manufacturing data. 

  • We use Dif() to calculate the rate of change (slopes, or derivatives), which can be correlated to our target of interest.
  • Lag() is also used to align data (upstream and downstream equipment)

 

However, when having tables with a column indicating different groups, new users are out of luck.

 

Two consecutive rows can belong to different groups and the only way to guarantee this is by adding complex formulas with conditionals (example).

 

It will be much easier for the user to include a <byVar> argument in Dif() and Lag().

 

For example, Col Cumulative Sum() is another row function that does allow this!

 

Here, I am creating a simple counter where I don't need to be worried about conditionals.

FN_0-1680879298556.png

 

1 Comment
hogi
Level XI
Saturday
Saturday

another important function where Byvar is missing:
 Group by - sooo useful!!! how about Interpolate?