Time binning - how to change the Tick labels?Among other Graphing Improvements - New in JMP 16 , the new Time Bin (&Wrap) option is extremely useful:
Continuous values are binned and represented as ordinal values. [edited]
The only issue:
The axis and grid look a bit chaotic:
I'd prefer a more structured view like this one - with long divider and lower frame:
but the settings for Tick labels and grids:
... are missing in the GUI for Axis with Time Bin settings:
Why?
Data Exploration and VisualizationRe: Time binning - how to change the Tick labels?If the user wants to bin by week - to get Plots for Year & week, there is another issue (#2):
by default, JMP creates the binned date with the format DD / MM / YYYY.
So, instead of week, still dates (with day and month) is used up as axis labels.
So, how to tell JMP that the week should be used.
Plan A:
- adjust the Format of the current axis - to use Week instead of day and month. and indeed, it works - but the user has to do the job for every single plot he wants to adjust.
Better:
The user can directy change the Format of the column (see code below) - then the week also gets into the axis labels:
even cooler: If the user enables nesting on the axis, JMP automatically shows the week AND the year - nested.
but wait - label nesting seems to have an issue with ISO Dates , Argh !!!
Why does the center plot show 2022 instead of 2023?!??!
Converting Week and Week2 to Format "Best" shows: both columns have the same entries. So, it's not an issue of the column, right?
New Table( "test",
Add Rows( 2 ),
Compress File When Saved( 1 ),
New Column( "date",
Format( "d/m/y", 10 ),
Set Values( [3768422400, 3797366400] )
),
New Column( "Week[date]",
Format( "Format Pattern", "<YYYY> cw<WW>", 15 ),
Formula( Date Increment( :date, "Week", 0 ) )
),
New Column( "Week[date]_2",
Format( "Format Pattern", "<DL><DD>.<MM>.<YYYY>", 15 ),
Formula( Date Increment( :date, "Week", 0 ) )
)
);
Graph Builder(
Variables( X( :date ), X( :"Week[date]"n ),X( :"Week[date]_2"n ) ),
Elements( Position( 1, 1 ), Points( X ) ),
Elements( Position( 2, 1 ), Points( X ) ),
Elements( Position( 3, 1 ), Points( X ) ),
SendToReport(
Dispatch( {}, "date", ScaleBox, {Label Row Nesting( 2 )} ),
Dispatch( {}, "Week[date]", ScaleBox, {Label Row Nesting( 2 )} ),
Dispatch( {}, "Week[date]_2", ScaleBox, {Label Row Nesting( 2 )} )
)
); <P><BR />-> <A href="https://community.jmp.com/t5/JMP-Wish-List/some-improvements-bugfixes-for-nested-binned-time-date-axes/m-p/762949#U762949" class="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa" target="_blank">some improvements + bugfixes for nested binned time/date axes</A> </P></YYYY><LINGO-SUB id="lingo-sub-762925" slang="en-US" mode="CREATE">Re: Time binning - how to change the Tick labels?</LINGO-SUB><LINGO-BODY id="lingo-body-762925" slang="en-US" mode="CREATE"><P>An Issue (1): <BR />The below code generates a graph like this:</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1717848274119.png" style="width: 400px;"><SPAN class="lia-inline-image-display-wrapper" image-alt="hogi_0-1717848274119.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="hogi_0-1717848274119.png" style="width: 400px;"><img src="https://us.v-cdn.net/6038925/uploads/images/65012i8AD5B913238B428F/hogi_0-1717848274119.png" role="button" title="hogi_0-1717848274119.png" alt="hogi_0-1717848274119.png" /></span></SPAN></SPAN></P><P> </P><P>Unfortunately the</P><PRE><CODE class=" language-jsl">Date Increment(., "Week", 0) = 01Jan0000;ruins the scale on the x axis.
Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" );
:Event Date[1] = .;
Graph Builder(
Transform Column(
"Week[Event Date]",
Format( "Format Pattern", "<MM></MM>
", 15 ),
Formula( Date Increment( :Event Date, "Week", 0 ) )
),
Variables( X( :"Week[Event Date]"n ) ),
Elements( Bar( X, Legend( 4 ) ) )
);
... so, one has to fix the formula manually via
If(is missing(:Event Date), ., Date Increment( :Event Date, "Week", 0 ))
Re: Time binning - how to change the Tick labels?For some seconds I thought that going via Time Bin could fix the issue with the too dynamic adjustment of the tick spacing in Graph builder: Heatmap - option: fixed Tick spacing (aggregation area) .
But clear: if it's just a transform column - and there is still the continuous axis scale, which is affected by the rescale bug.
Re: Time binning - how to change the Tick labels?It seems like that is the only option you currently have (I haven''t tried if you could force those by scripting).
Re: Time binning - how to change the Tick labels?You are right, besides being quite "ordinal", the values stay "continuous" - displayed on a continuous time scale.
I would say: tick labels are for continuous variables as well:
... but quite unfortunately, the cool tick label settings to adjust the graph are missing.
So, the only way it to manually change the modeling type to ordinal/nominal of the created transform column.
But then:
- I lose the Label row nesting functionality
- months with missing data will just be removed from the plot ( at least till:folded_hands: Column Property: Inclusive Values is available ...) (*)
At the moment, I think the only way is:
generate Year and month manually as ordinal values and then nest them on the x axis. [with issue (*)]
right?
Re: Time binning - how to change the Tick labels?Have you made sure your columns are nominal/ordinal (I think tick labels are for categorical variables)?
https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/customize-axes-and-axis-labels-in-graphs.shtml#
