Report data corrupted (shows averages) SOLVED

Hi,

I have a template with an integer datastream for which I save the raw data:

I downloaded a report from one of my devices and I am seeing strange values.

I think somehow the values are not being saved as raw anymore and are now saved as averages…? :frowning:
This is production so how can I get the original values and how do I correct this for the future logging?

New report downloaded today.

12/15/21 03:35:00 PM,Status Game Controller,1.0
12/15/21 03:34:00 PM,Status Game Controller,12.333333333333334
12/15/21 03:33:00 PM,Status Game Controller,4.25
12/15/21 03:32:00 PM,Status Game Controller,8.666666666666666
12/15/21 03:31:00 PM,Status Game Controller,2.0
12/15/21 03:30:00 PM,Status Game Controller,33.0
12/15/21 03:29:00 PM,Status Game Controller,1.6666666666666667
12/15/21 03:28:00 PM,Status Game Controller,8.666666666666666
12/15/21 03:27:00 PM,Status Game Controller,2.0
12/15/21 03:26:00 PM,Status Game Controller,33.0
12/15/21 03:25:00 PM,Status Game Controller,2.0
12/15/21 03:19:00 PM,Status Game Controller,6.5
12/15/21 03:18:00 PM,Status Game Controller,4.25
12/15/21 03:15:00 PM,Status Game Controller,12.0
12/15/21 03:14:00 PM,Last Reset Reason nr,4.0
12/15/21 03:13:00 PM,Status Game Controller,17.0
12/15/21 03:12:00 PM,Status Game Controller,2.0
12/15/21 03:10:00 PM,Last Reset Reason nr,4.0
12/15/21 03:09:00 PM,Status Game Controller,12.5
12/15/21 03:07:00 PM,Status Game Controller,2.0
12/15/21 03:06:00 PM,Status Game Controller,31.0
12/15/21 03:04:00 PM,Status Game Controller,2.0

Report I downloaded more then a month ago:

12/15/21 03:35:40 PM,Status Game Controller,1.0
12/15/21 03:34:39 PM,Status Game Controller,2.0
12/15/21 03:34:12 PM,Status Game Controller,33.0
12/15/21 03:34:02 PM,Status Game Controller,2.0
12/15/21 03:33:51 PM,Status Game Controller,12.0
12/15/21 03:33:40 PM,Status Game Controller,2.0
12/15/21 03:33:11 PM,Status Game Controller,1.0
12/15/21 03:33:10 PM,Status Game Controller,2.0
12/15/21 03:32:57 PM,Status Game Controller,23.0
12/15/21 03:32:46 PM,Status Game Controller,2.0
12/15/21 03:32:20 PM,Status Game Controller,1.0
12/15/21 03:31:19 PM,Status Game Controller,2.0
12/15/21 03:30:10 PM,Status Game Controller,33.0
12/15/21 03:29:56 PM,Status Game Controller,2.0
12/15/21 03:29:41 PM,Status Game Controller,1.0
12/15/21 03:29:40 PM,Status Game Controller,2.0
12/15/21 03:28:54 PM,Status Game Controller,23.0
12/15/21 03:28:45 PM,Status Game Controller,2.0
12/15/21 03:28:19 PM,Status Game Controller,1.0
12/15/21 03:27:18 PM,Status Game Controller,2.0
12/15/21 03:26:02 PM,Status Game Controller,33.0
12/15/21 03:25:52 PM,Status Game Controller,2.0
12/15/21 03:19:30 PM,Status Game Controller,1.0
12/15/21 03:19:28 PM,Status Game Controller,2.0
12/15/21 03:19:23 PM,Status Game Controller,21.0
12/15/21 03:19:08 PM,Status Game Controller,2.0
12/15/21 03:18:57 PM,Status Game Controller,1.0
12/15/21 03:18:56 PM,Status Game Controller,2.0
12/15/21 03:18:44 PM,Status Game Controller,12.0
12/15/21 03:18:33 PM,Status Game Controller,2.0
12/15/21 03:15:32 PM,Status Game Controller,22.0
12/15/21 03:15:21 PM,Status Game Controller,2.0
12/15/21 03:14:14 PM,Last Reset Reason nr,4.0
12/15/21 03:13:37 PM,Status Game Controller,2.0
12/15/21 03:13:34 PM,Status Game Controller,32.0
12/15/21 03:12:49 PM,Status Game Controller,2.0
12/15/21 03:10:15 PM,Last Reset Reason nr,4.0
12/15/21 03:09:39 PM,Status Game Controller,2.0
12/15/21 03:09:32 PM,Status Game Controller,23.0
12/15/21 03:07:30 PM,Status Game Controller,2.0
12/15/21 03:06:02 PM,Status Game Controller,31.0
12/15/21 03:04:23 PM,Status Game Controller,2.0

Just noticed that there is a difference in downloading a week report:

02/04/22 02:47:44 PM,Status Game Controller,11.0
02/04/22 02:47:19 PM,Status Game Controller,2.0
02/04/22 02:46:15 PM,Status Game Controller,13.0
02/04/22 02:46:02 PM,Status Game Controller,2.0
02/04/22 02:45:54 PM,Last Reset Reason nr,3.0
02/04/22 08:25:58 AM,Status Game Controller,1.0
02/04/22 08:25:56 AM,Status Game Controller,2.0
02/04/22 08:25:49 AM,Status Game Controller,13.0
02/04/22 08:25:37 AM,Status Game Controller,2.0
02/04/22 08:25:28 AM,Status Game Controller,1.0
02/04/22 08:25:27 AM,Status Game Controller,2.0
02/04/22 08:25:15 AM,Status Game Controller,12.0
02/04/22 08:25:05 AM,Status Game Controller,2.0
02/04/22 08:24:53 AM,Status Game Controller,1.0
02/04/22 08:24:49 AM,Status Game Controller,2.0
02/04/22 08:23:02 AM,Status Game Controller,12.0
02/04/22 08:22:51 AM,Status Game Controller,2.0
02/04/22 08:22:41 AM,Status Game Controller,1.0
02/04/22 08:22:40 AM,Status Game Controller,2.0
02/04/22 08:22:37 AM,Status Game Controller,21.0
02/04/22 08:22:26 AM,Status Game Controller,2.0
02/04/22 08:22:17 AM,Last Reset Reason nr,4.0
02/04/22 08:22:15 AM,Status Game Controller,2.0
02/04/22 08:22:13 AM,Status Game Controller,21.0
02/04/22 08:21:50 AM,Status Game Controller,2.0
02/04/22 08:21:37 AM,Status Game Controller,1.0
02/04/22 08:21:34 AM,Status Game Controller,2.0
02/04/22 08:21:18 AM,Status Game Controller,33.0
02/04/22 08:21:08 AM,Status Game Controller,2.0
02/04/22 08:20:54 AM,Status Game Controller,1.0
02/04/22 08:20:53 AM,Status Game Controller,2.0
02/04/22 08:20:36 AM,Status Game Controller,21.0
02/04/22 08:20:25 AM,Status Game Controller,2.0
02/04/22 08:20:13 AM,Status Game Controller,1.0
02/04/22 08:20:11 AM,Status Game Controller,2.0
02/04/22 08:19:25 AM,Status Game Controller,33.0
02/04/22 08:19:05 AM,Status Game Controller,2.0
02/04/22 08:02:15 AM,Last Reset Reason nr,7.0

and a 3 month report:

02/04/22 02:47:00 PM,Status Game Controller,6.5
02/04/22 02:46:00 PM,Status Game Controller,7.5
02/04/22 02:45:00 PM,Last Reset Reason nr,3.0
02/04/22 01:41:00 PM,Nr of modem restarts,1.0
02/04/22 12:42:00 PM,Nr of modem restarts,1.0
02/04/22 12:22:00 PM,Nr of modem restarts,1.0
02/04/22 12:14:00 PM,Nr of modem restarts,1.0
02/04/22 11:38:00 AM,Nr of modem restarts,1.0
02/04/22 10:38:00 AM,Nr of modem restarts,1.0
02/04/22 10:22:00 AM,Nr of modem restarts,1.0
02/04/22 09:46:00 AM,Nr of modem restarts,1.0
02/04/22 09:38:00 AM,Nr of modem restarts,1.0
02/04/22 09:19:00 AM,Nr of modem restarts,1.0
02/04/22 08:54:00 AM,Nr of modem restarts,1.0
02/04/22 08:50:00 AM,Nr of modem restarts,1.0
02/04/22 08:25:00 AM,Status Game Controller,4.375
02/04/22 08:24:00 AM,Status Game Controller,1.5
02/04/22 08:23:00 AM,Status Game Controller,12.0
02/04/22 08:22:00 AM,Status Game Controller,7.285714285714286
02/04/22 08:22:00 AM,Last Reset Reason nr,4.0
02/04/22 08:21:00 AM,Status Game Controller,8.0
02/04/22 08:20:00 AM,Status Game Controller,4.833333333333333
02/04/22 08:19:00 AM,Status Game Controller,17.5
02/04/22 08:02:00 AM,Last Reset Reason nr,7.0
02/04/22 08:02:00 AM,Nr of modem restarts,1.0

okay I found the issue, when you select a three months report it automatically switches to 1 minute data aggregation, you need to go into advanced settings of report and specifically select raw…

1 Like