Add average to a Scatter Chart

[Kimkpg]

I need help with adding the average to a Scatter Chart.

I’ve created a Scatter Chart to show the distribution of the time in days to a specific task (this number is calculated by the finish date - start date), this thing I got fine

however when I try to add the average point/line/whatever the graphic breaks, and stop showing any data.

 

how can I be able to this? 

[Olivier Keugue Tadaa]

Let us know your data structure (columns and types) or a sample content.
Also your faulty "average" expression. Do you have any error messages on the scatter plot ?

Note that when you apply an aggregation (e.g. sum, avg etc..) on the scatter plot, it becomes similar to a bubble chart and therefore you should ensure you have properly defined the  Marker-By property (see below)