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
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.