MATLAB Answers

Martin
0

Monthly turnover where I need the sum

Asked by Martin
on 17 Jul 2019
Latest activity Answered by Steven Lord
on 17 Jul 2019
Hi, I have a x 2 table like this:
Rows can vary from 1:inf.
I need sum of the monthly Turnover (2. column) from timestamp (1. column) (last row is latest time and the "anchored" timestamp - means i need turnover 1 month prior that latest time in the bottom). Anyone know a way out of this? Keep in mind if there is no full month in 1. column (there could be only, say, 3 rows) then I need the sum of it all.

  0 Comments

Sign in to comment.

1 Answer

Answer by Steven Lord
on 17 Jul 2019

If all the entries in the Time variable in your table were valid date strings that datetime could understand, I would first convert that variable into a datetime array. Next I would call table2timetable to make a timetable from the table. Finally I would call retime or groupsummary on that timetable.
As shown the Time variable in the table contains at least one element that datetime will not be able to understand: 'Start'. Can you remove that or replace it with the actual starting time for your data set? If so you could try the process I described.

  0 Comments

Sign in to comment.