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.

The AVERAGEIF is not [yet?] a supported function of Apache POI: https://poi.apache.org/spreadsheet/eval-devguide.html

var pvd = this.pvd; if(!pvd) { pvd = this.pvd = com.serotonin.m2m2.Common.databaseProxy.newPointValueDao(); } print( p.value ); print( p.time ); var loggedValue = pvd.getPointValueBefore( p.getDataPointWrapper().getId(), p.time + 1 ); print( loggedValue.doubleValue ); //if numeric point print( loggedValue.time ); While this could perhaps be more straightforward, I am having a tough time figuring out why one would be polling a virtual data source to get an interval logging rollup and then compute something off the interval values. It would seem to me to make more sense to record all data from the edge data source, and use the statistics functions in the scripting environment to compute the interval value you wish to use in the script body. That way if you have some anomalies you can still view the original data.

Hi Felicia, It doesn't look like there really is a direct way to achieve what you're asking. However, have you considered putting the pie chart inside a div with another div absolutely positioned into the place you'd like the label? Something like... <div> <ma-pie-chart style="position:relative;" ...></ma-pie-chart> <div id="pie-chart-center-label" style="position:relative; left: 75px; top: 55px;">Value: {{myPoint.value}}</div> </div>

Hi Felicia, I'm still not sure I understand. Why couldn't you use the XID field in the manner you are describing?

@phildunlap, Thanks, it works! It does make a difference between small capitals and big capitals. Regards, Felicia