Re: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)

Update:

Intraday merits

Converted dataset (since 1st Jan. 2019)

Code:

. list id merit date day month2 year week month dofw if year == 2019

   +-----------------------------------------------------------------------------+
   | id merit date day month2 year week month dofw |
   |-----------------------------------------------------------------------------|
343. | 343 603 01jan2019 1 1 2019 2019w1 2019m1 Tuesday |
344. | 344 526 02jan2019 2 1 2019 2019w1 2019m1 Wednesday |
345. | 345 394 03jan2019 3 1 2019 2019w1 2019m1 Thursday |
346. | 346 1082 04jan2019 4 1 2019 2019w1 2019m1 Friday |
347. | 347 835 05jan2019 5 1 2019 2019w1 2019m1 Saturday |
   |-----------------------------------------------------------------------------|
348. | 348 783 06jan2019 6 1 2019 2019w1 2019m1 Sunday |
349. | 349 570 07jan2019 7 1 2019 2019w1 2019m1 Monday |
350. | 350 782 08jan2019 8 1 2019 2019w2 2019m1 Tuesday |
351. | 351 1161 09jan2019 9 1 2019 2019w2 2019m1 Wednesday |
352. | 352 987 10jan2019 10 1 2019 2019w2 2019m1 Thursday |
   |-----------------------------------------------------------------------------|
353. | 353 878 11jan2019 11 1 2019 2019w2 2019m1 Friday |
354. | 354 711 12jan2019 12 1 2019 2019w2 2019m1 Saturday |
355. | 355 978 13jan2019 13 1 2019 2019w2 2019m1 Sunday |
356. | 356 1127 14jan2019 14 1 2019 2019w2 2019m1 Monday |
357. | 357 813 15jan2019 15 1 2019 2019w3 2019m1 Tuesday |
   |-----------------------------------------------------------------------------|
358. | 358 880 16jan2019 16 1 2019 2019w3 2019m1 Wednesday |
   +-----------------------------------------------------------------------------+