cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
DJ_Kim
Level III

How to Change Date Grouping in Graph Builder

DJ_Kim_0-1742348836326.png

 

 

Hello,

As shown in the image, I would like to group specific data by date. When creating an X-axis group,

the data is automatically grouped at 5, but I would like to group it by month or 2month.

Is there a way to configure this setting within Graph Builder?

Thank you.

1 REPLY 1
txnelson
Super User

Re: How to Change Date Grouping in Graph Builder

There are a couple of options.

  1. Change the format of the Date column in your data table.  If you specify a format of m/y it will group based on the months.  If you specify yyyyQq it will group based on quarters.
  2. You can also right click in the Group area and select
    1. Levels=>Custom Levels
    2. Levels=>Create  Transform Colum

Either of these options will let you options to set the groupings

Jim

Recommended Articles