I want to plot this on a line chart with Y axis as Avg, and X-Axis as Date. I want to plot all the values for a date, when I tried this it shows the option for Sum,Average,Minimum etc instead of having the option to plot all the points in each date.
I would also like to show the name and full name for each point on the chart, is it possible to show it on the x-axis grouping by Date as below
Is it also possible to have 2 reference lines. I can see the option to add one reference line. This is indicate if the average has goone above or below a certain point.