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
View Original Published Thread

Dates on an X-axis for graph builder

jan_solo_ff
Level II

Hi,

 

With the upgrade to JMP 18 we broke a script that displays results over time.

It seems I'm not able to tell the graph builder that the x-axis are dates.  The column is formatted as date (yyyy-mm-dd).  When I import the dates into the graph, all dates get a value and are displayed based on that value.  However, this results in an incorrect graph:

 

2025-02-01 - Value 0

2025-02-02 - Value 1

2025-03-01 - Value 2

 

There will be just as much space between all values, but there is a big difference of days between those dates!

Also, we did set the increments to a week.  How would I do this in the case above?  We also would like to have the thick starting on the same day (eg monday) for each chart.

 

Is there a way to do this in JMP 18?

 

jan_solo_ff_0-1741365443223.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jan_solo_ff
Level II


Re: Dates on an X-axis for graph builder

I cant put the data here, company policy.  However, I was able to figure it out with your reply.

Once I changed the modeling type to 'Continuous', I could work with dates again.

 

jan_solo_ff_0-1741371293956.png

 

Thank you!

View solution in original post

2 REPLIES 2
jthi
Super User


Re: Dates on an X-axis for graph builder

Can you provide example data? Are your dates properly formatted as dates (numeric and not character)? What is the modelling type?

-Jarmo
jan_solo_ff
Level II


Re: Dates on an X-axis for graph builder

I cant put the data here, company policy.  However, I was able to figure it out with your reply.

Once I changed the modeling type to 'Continuous', I could work with dates again.

 

jan_solo_ff_0-1741371293956.png

 

Thank you!