I have been searching for a way to do this as well. Average by certain rules… average of combined pins by other variable metrics like per minute.
I was also hoping to have the charts change colors if levels were rising or falling at too fast or slow of a given rate.
My best option is having to create a view in the database and charting that, annoying problem is the historian is broken into multiple tables for date ranges… it is getting complicated having to decode all the sub tables and their relations only to get what you would think would be a common charting feature… comparisons, trends and averages are what the suits want to see. Projections would be nice as well.
I am new to this so if there is a way that I am unaware of please point me to the documentation and an example if available.