topic Problem time axis settings graph builder in Discussions

Problem time axis settings graph builder

frankderuyck — Sat, 10 Jun 2023 23:59:31 GMT

I have a problem with time axis settings in graph builder see file in attachment. When I use the full time axis scale for factor "Tijd" it is OK but adjusting axis settings to a more narrow "Tijd" scale I get a blank graph with increment time setting that don't correspond to my requested adjustments. Also (not shown), I can't concatenate this data set with another one, time/Tijd distribution goes wrong: I get a two line histogram. What is the problem with this time/Tijd factor? How to solve

Re: Problem time axis settings graph builder

txnelson — Mon, 27 Mar 2023 12:24:03 GMT

The JMP date/time values are based upon the number of seconds from the date midnight, January 1, 1904. The applying a format on a date/time column, does not change the underlying numerical value. Below I have taken the graph where you have not restricted the X axis range, and just changed the format being displayed and overlapped it with the original axis.

The axis shows a range that covers only the day of December 31, 1899. On your second graph, somehow the axis range has been set across a date range starting beyond any date/time in you data, December 31, 1899 10:44:14 AM to January 1, 1904 12:00:00.

My guess is that this is happening by setting the Minimum and Maximum with just the time part of the date/time column. I suggest that you change your format to a date/time format, set the range, and then change the format to your desired time only format.

Re: Problem time axis settings graph builder

MRB3855 — Mon, 27 Mar 2023 12:38:39 GMT

Your "more narrow "Tijd" scale" is actually a wider scale...a lot wider. And this new scale does not include the data. That's why the data are not visible in your "new/" one.

Your original, then new (and the new scale is reversed).

Your max in the second one must be <= min from the one above.

Re: Problem time axis settings graph builder

frankderuyck — Mon, 27 Mar 2023 21:09:48 GMT

Sorry, not yet a solution: when I narrow time scale as below

I Get a blank graph with a correct time scale and increment..

Re: Problem time axis settings graph builder

txnelson — Mon, 27 Mar 2023 21:16:49 GMT

Change the format from "h:m:s" to "m/d/y h:m:s" and I believe you will see that the "m/d/y" component of the date/time column is outside of the range of the data you have in your data table. All of your data has an m/d/y of 12/31/1899.

Re: Problem time axis settings graph builder

frankderuyck — Tue, 28 Mar 2023 06:44:22 GMT

Thanks Jim, I see , something must have gone wrong during data processing. Date (datum column) is OK, no idea where that 1899 comes from (??) Guess no solution to link with 1918 dates in datum column and start all over again..