I have a line chart like this:
![lailarhc_0-1642095489891.png lailarhc_0-1642095489891.png](/t5/image/serverpage/image-id/70191i9CAAB2E5947BBA33/image-size/medium?v=v2&px=400)
Where Dimension 1 is a drill-down dimension with Year and month.
Dimension 2 is the name of each employee:
=NomeEmpregado
And the measure represents how many courses each employee has taken:
=count( distinct {<Tipo={'Turmas'}, lotatual={"000075"} >+< lotatual={"00075*"}>} if(IsNull(DataSaidaEmpregado) and (Not isNull(CodEvento)), CodEvento & '|' & CodEmpregado))
I need to add an average permanent line based on an expression value, not a straight reference line.
This is the line graph with the average courses per employee each year:
![lailarhc_1-1642095816511.png lailarhc_1-1642095816511.png](/t5/image/serverpage/image-id/70192iCB1AAF5A0C2949F1/image-size/medium?v=v2&px=400)
I want to add this average line to my first graph, so that I have this average line as a permanent feature, no matter the selection. It needs to be always there so I can compare how many courses an employee has taken against the average numbers of courses per employee in a given period of time.
How can I accomplish this?