| Author |
 Topic  |
|
|
AOjuva
11 Posts |
 Posted - 10/07/2020 : 07:08:48 AM
|
I have a column with date and time values. The measurement series runs over several days, actually for three months, with approximately 32000 data points for each day.
To make analysis more workable, I want to unstack the data so that each day has separate colums. I know how to unstack columns using a grouping column, and I got the data to stack in the way I wanted by making a column that was a copy of the date value, but it only showed the day number. Then I had another column which only showed the time of the day (hh:mm), which I used as X.
The problem is, that I want to plot certain days on each other. However, when I plot these values in the same graph, they don't have a common zero, but form a continuous series, probably because the time column still contains information about the Julian day value.
So, how do I get my data grouped per day, and labelled only by time of that day, if I have one column with Julian values and another column of data points?
Thanks in advance! |
|
|
YimingChen
1592 Posts |
Posted - 10/07/2020 : 09:25:35 AM
|
Hi,
From what you described, you would like to extract the time value from your Julian day value. Basically the fractional segment of the Julian date/time value is the time part and the integer segment is date part. See figure below, set col(B) as the fraction of col(A), then set col(B) Format to Time. Simply changing the Display format of col(A) to only show time part doesn't change the Julian date value behind it.
We have webinar talking about Date/Time, you may want to check it out.
https://www.originlab.com/Index.aspx?go=SUPPORT/ONLINETRAINING&pid=3169
James |
Edited by - YimingChen on 10/07/2020 09:27:10 AM |
 |
|
|
AOjuva
11 Posts |
Posted - 10/09/2020 : 02:32:38 AM
|
| Perfect, thank you! |
|
|
| |
Topic |
|
|
|
Column formatting question