topic Re: Dates on an X-axis for graph builder in Discussions

Dates on an X-axis for graph builder

jan_solo_ff — Fri, 07 Mar 2025 16:50:47 GMT

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?

Re: Dates on an X-axis for graph builder

jthi — Fri, 07 Mar 2025 17:00:34 GMT

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

Re: Dates on an X-axis for graph builder

jan_solo_ff — Fri, 07 Mar 2025 18:17:03 GMT

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.

Thank you!