I am having some trouble getting the information I am looking for from a report.
I have a tag historian query providing a 10min time-weighted average from a group of tags. simplified version pictured below:
I would like to report the maximum value per day from the 10 min results. From reading other threads I think I might be required to create a query using a script. so far I have been able to return the maximum value from the entire dataset but I require the max of the 10min results each day, for any given date range.
Header = ['date','val'] NewDataset =  rawDataset = data['DailyAverage10min'].getCoreResults() for row in range(rawDataset.rowCount): date = rawDataset.getValueAt(row,'t_stamp') val = max(rawDataset.getColumnAsList(rawDataset.getColumnIndex("val"))) NewDataset.append([date, val]) NewDataset = system.dataset.toDataSet(Header, NewDataset) data ['NewDailyAverage10min'] = NewDataset
any advice appreciated.