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