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.
How do Excel reports handle no datapoints
-
I'm generating some excel reports and I've run into an interesting predicament. Let's say a point doesn't change values for a week and subsequently nothing is logged in that week. If I run a report for that week on that point what should the output be?
I tried to run the report with a rollup of first and got nothing out. I assume that is because the point did not have any datapoints in that time range but I would have kind of expected it to give me whatever the last value of that point was. -
points get logged with a {"time":"value"}. So if there are no time stamps within the period then no log entries will get pulled to the report.
I assume you are using 'on change' logging. You could change this to an interval and change. That way you will at least have regular log entries.
-
Hi psysak,
I tried to run the report with a rollup of first and got nothing out. I assume that is because the point did not have any datapoints in that time range but I would have kind of expected it to give me whatever the last value of that point was.
Providing the value before the period or the first value in the period is the distinction between the
Start
andFirst
rollups.https://help.infiniteautomation.com/mango-rollups-and-statistics/
-
@phildunlap said in How do Excel reports handle no datapoints:
g the value
Thanks guys, my curiosity has been satisfied.