Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nezuko_kamado
Creator
Creator

Time Series plotting for data has separated day and hour columns

My data has separated Day and hour(=Zulu), and I need to draw a time series plot with the order of Zulu/Day/Month/Year.

Such an order of 0/01/01/2020  ->  1/01/01/2020  ->2/01/01/2020    and so on..

How can I adjust them at the load editor?  or can I combine and adjust them directly and  a plot chart?

YearMonthDayZuluValue
20201102
20201113
20201125
20201134
202011411
202011543
20201163
202011735
20201184
202011967
202011102
202011113
202011125
202011134
2020111411
2020111543
202011163
2020111735
202011184
2020111967
202011203
2020112135
202011224
2020112367
20201202
20201213
20201225
20201234
202012411
20201253
202012635
Labels (4)
1 Reply
MayilVahanan

Hi

Try like below

LOAD *, Dual(Zulu&'/'&MakeDate(Year, Month, Day), NUm(Zulu&Day&Month&Year)) as DateFormat INLINE [
Year, Month, Day, Zulu, Value
2020, 1, 1, 0, 2
2020, 1, 1, 1, 3
2020, 1, 1, 2, 5
2020, 1, 1, 3, 4
2020, 1, 1, 4, 11
2020, 1, 1, 5, 43
];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.