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.
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