Hi all My task is going to build a bar chart with a a straight average line across the bars, could you send some lights on creating the average distinct count variable please? Currently the line is a trend line but I need a straight line cross the bars. Like the red line in below chart.   Variables: Event ID - Distinct count (Event ID set as distinct count) Event assigned QID upper northland (staff ID)   The formula and expected(in red line)/current(orange line) chart as below:   formula like sum the distinct count then divide by the distinct count staff id   Sum [_ForAll_] (AggregateTable(_Sum_, Table(_Avg_, Fixed( 'EventNum-string'n, 'Event Assigned QIDs - upper northland'n), 'Frequency'n))) / Distinct [_ByGroup_] ( 'Event Assigned QIDs - upper northland'n)         Thanks AC ... View more