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.
Excel Reports not grouped by datetime
-
Hy,
I'm trying to create a report containing info from several datasource of our application, I've seen that also choosing same sample time of 1 minute for all data source, the result is that we have several row for the same datetime, how can I group all the raws about same datetime?
-
Hi etantonio,
So, you have multiple data sources with the same polling interval but because the may have started at different instants, the rows in your Excel reports are very close in timestamp but there are many blank cells. Do I understand correctly? Can you post a screenshot of your configuration of the report? Have you tried using a rollup over a 1 minute period, getting the first, start, or last value as the rollup type?
-
-
also using 1 minute rollup there are always more rows for the same datetime
-
now it seems ok using
rollup first 1 minute
but often I need to start and stop mango after adding new points to the template, otherwise the report is not created
-
Can you say more about that? What do you mean the report is not created? It is running forever, or it has an error, or what?
-
the report is running forever, and it seems there aren't errors in the log.
After Mango start and stop the report is finished -
it seems could be enough also a refresh of the page
-
there's a way to avoid these empty rows?
actually these are my settings:
-
It is likely that the point did not have a value recorded in the 1 minute window of the rollup for whatever reason (maybe it didn't poll, maybe it is log on change) and the "First" is defined as the first value within the period, while the "Start" is defined as the value of the point at the start of the period. So, change your rollup to "Start" and those rows will likely contain the values above them repeated in those cells. https://help.infiniteautomation.com/mango-rollups-and-statistics/
-
Start is not available on Mango 2.8,
it is possible to obtain the same result in another way?
-
any other idea about how to avoid the first empty row in the report?
-
You could change the logging type of the points to either an interval or interval change type (I am guessing they are currently log on change?).
