search

GridProtectionAlliance / osisoftpi-grafana

Grafana Data Source Plugin for the OSIsoft PI System
https://grafana.com/plugins/gridprotectionalliance-osisoftpi-datasource
Apache License 2.0
58 stars 30 forks source link

Please help, I can't get Summary Total to work in new 5.1.0 #172

Open SC-66 opened 1 week ago

SC-66 commented 1 week ago

This is said to be corrected in 5.1.0, but if so, I need help to understand how to use it. I have a data set with values on with summary basis event-weighted, i.e. data come on erratic basis. The first picture below show the dataset in table panel, and the table summarizes it to 20.9 using recorded values. (correct total). Then I do Summary Enable, Total, and the Total value is not correct. Am I doing wrong? There is this new "Enable interval", but I can not understand how to use it, and since the data is event based, using sampling interval can't be correct way.

image

and then I use Summary Total: image

pvmagacho-nde commented 1 week ago

Turn off the recorded values. and turn on only the summary enable. check the query using query inspector and check if that what you want from the PiWebAPI.

SC-66 commented 4 days ago

I tried that but no change. I have created an excel file to compare the different result of the Summary types. As you see the result is the same when using recorded and non recorded values. I must use the Recorded values since adding the interpolated values gives wrong result. Also, the min, max and range summaries works, but not the total, average, stddev, stdevpopulation and count. The picture below shows the correct (expected) result and the result using 5.1.0 using Recorded values = ON and Recorded values = OFF. I have also attached the Query and the JSON Dataframe for both the 4.2.0 and the 5.1.0 so you can see the differences. I have removed classified info.

image PI Issues - #172.xlsx DataFrame-4.2.0 - #172.txt DataFrame-5.1.0 - #172.txt Query-4.2.0 - #172.txt Query-5.1.0 - #172.txt