Invc Sales Order Number = Invoice # that will exist across multiple events Inv = $$ I need to sum the Inv for Each Distinct "Invc Sales Order Number", then average the total to arrive at an Average for each unique sum. Then i would like to timechart it to show trend. With the search below I am able to calculate and display an accurate Average, but am not able to timechart the Average below: ......| stats dc("Invc Sales Order Num") as Invoices sum(Inv) as Revenue | eval Average=Revenue/Invoices ... View more