Scatter plot with multiple y-values per x-value (categorical).
Via Lines & Curves setting, add a line that's calculated per x-value - i.e., a way to generate an average of the y-axis values for each distinct x-axis value, then connect adjacent pointwise averages with straight-line segments, in a Scatter Plot.
Current State
When adding an average horizontal line via Lines & Curves setting, the line is calculated over the whole data, and not per x-value.
Attached screenshot to compare current state vs. goal.