topic Re: hour axis in Israel JMP Users - קבוצת משתמשים - ישראל

hour axis

eranse — Thu, 14 Nov 2019 08:48:06 GMT

hi,

Maybe a basic issue but in graph builder (JMP14.2) I can't create an axis which will range from 6am (min) to 02am (max)the following day. When I try to set the minimum value at 06:00 and the maximum at 02:00 the axis immediately switches the min and max.

I need the events which occured after midnight to apear higher i.e. later in the time period, but they always apear below - lower on the scale. What am I doing wrong?

Thanks

Eran

Re: hour axis

tom_abramov — Thu, 14 Nov 2019 08:56:27 GMT

Hi Eran,

Sounds you need to add the date as well.

Or use Column Property "Value Ordering" to set up a specific order of values.

If you don't succeed, please attach the data.

Regards,

Tom Abramov.

Re: hour axis

eranse — Thu, 14 Nov 2019 09:15:44 GMT

Hi Tom,
I thought about that but each data point (There are more than a 1000) has a different date – I am interested in the hour distribution over the day

[cid:image001.png@01D59ADC.D345D770]

The small groups on the bottom should be on top of the graph. Adding the date to each point would make it an impossible.

[cid:image002.png@01D59ADC.D345D770]

eran

Re: hour axis

tom_abramov — Thu, 14 Nov 2019 09:26:45 GMT

The pics are not attached...

Re: hour axis

eranse — Thu, 14 Nov 2019 16:48:50 GMT

Hi tom,

Thanks - I think the value ordering did the trick - was a bit lengthy but the final result seems ok

eran

Re: hour axis

tom_abramov — Fri, 15 Nov 2019 09:29:06 GMT

Not at all.
There is another trick (maybe for future cases) - choose column property "Row order levels". The values will be ordered in charts as they are ordered in the table.