topic Re: Column with dates in Discussions

Column with dates

Françoise — Thu, 08 Feb 2018 08:25:58 GMT

Hello,

I've these columns:

I would like to build a graph with de "Difference" on the axis Y (continuous values).

it doen't work because the format is "caracter".

How can I do it?

thanks for your help.

Françoise

Re: Column with dates

txnelson — Thu, 08 Feb 2018 11:26:25 GMT

You can easily convert all 3 of your columns into proper Date/Time columns for "Date hour preparation" and "date hour use" and into a duration column for the column called "Difference".

I will start with the column "Difference"

1. Right click on the column header for column "Difference" and choose "Column Info". You will see the following screen

2. Change the Data Type to Numeric. (A New format field will be displayed)

3. Change the Modeling Type to Coninuous

4. Change the Format to

Duration==>hr:m

The window will now look like

5. Click on the "Apply" button and the Difference Column will be changed to Numeric/Continuous

You can repeat the above steps for the 2 date/time columns, but instead of selecting a Duration format, select

Time==>d/m/y h:m

Which results in a data table looking like

Re: Column with dates

Françoise — Thu, 08 Feb 2018 14:09:58 GMT

ok, but when I change the data type in continuous numeric for the column "Difference", the values disappear!

Re: Column with dates

Bill_Worley — Thu, 08 Feb 2018 14:54:58 GMT

That is one of things that happen when you change a column from categorical to numeric. You can quickly recalculate the difference in a new column by highlighting the two columns of interest and then doing a right click in the column header area and selecting New Formula Column > Combine > Difference. A new column will be added to your data table with the difference. If that doesn't look exactly right try Difference (reverse order).

HTH

Re: Column with dates

txnelson — Thu, 08 Feb 2018 15:10:32 GMT

my assumption is that you selected a column format that didn't match properly

Re: Column with dates

Françoise — Thu, 08 Feb 2018 15:52:44 GMT

I can't do it.

can you dio it in the file" exemple.jmp"?

Re: Column with dates

Bill_Worley — Thu, 08 Feb 2018 18:41:05 GMT

To add to @txnelson's response and his previous images. All of your data types need to be converted to continuous for the difference calculation to work.