Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Unusual timestamp value in rollup Excel report
-
Heya,
I have created an Excel rollup report but I haven't figured out what the value for the timestamp is. It appears to be an incrementing value but what it means I don't know.
The values in the report are:
The timestamp appears to be incrementing by 0.000694444
The setup for the report is:
Any ideas/suggestions? I had expected a timestamp instead of a incrementing value.
Thanks
Ian -
That's excel formatting the timestamp strange. The secret to getting Excel to keep the right format is to put in at least two rows of values and get the timestamp and values formatted the way you want. This way when the report runs the format you specified in your template will be used.
-
Hi @JoelHaggar
Ahh, Excel my nemesis, we meet again :P
Thanks for the suggestion. I added 2 rows to the report template and the export is now working as I would expect.
Ian