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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.