• Recent
    • Tags
    • Popular
    • Register
    • Login

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Unusual timestamp value in rollup Excel report

    Scheduled Pinned Locked Moved User help
    3 Posts 2 Posters 1.1k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I Offline
      iperry
      last edited by

      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:
      0_1542149801489_f95cc844-ed4e-437a-8eb8-6e60bef72337-image.png

      The timestamp appears to be incrementing by 0.000694444

      The setup for the report is:
      0_1542149904498_f8f6507a-2940-4df2-970c-be4c6a23973b-image.png

      Any ideas/suggestions? I had expected a timestamp instead of a incrementing value.

      Thanks
      Ian

      1 Reply Last reply Reply Quote 0
      • JoelHaggarJ Offline
        JoelHaggar
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • I Offline
          iperry
          last edited by

          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.

          0_1542229499290_0ed22c39-16e4-4d96-a327-122f55915683-image.png

          Ian

          1 Reply Last reply Reply Quote 0
          • First post
            Last post