How to plot average as a reference line? / ¿Cómo graficar promedio como linea de referencia?

[#1]

Good afternoon,

I have a problem, I'm trying to draw a graph of the performance of basic daily activities of a project.

Now I have a table with information and the respective chart (attached).

SITIO            FECHA

SITIO 1        2/5/15

SITIO 2        2/5/15

SITIO 3        4/7/15

The problem is when I try to add a reference line. I need the average activities plot with the graph of performance (attached)

Attached is an example where the line noticed a reference to 2, need to come out but the average.

I tried with the following formulas and do not solve anything, it must be because I'm trying to get an average to a string of strings

AVG (SITIO)

Stay tuned, thanks.

[Anonymous]

What is the expression you use on your Chart ?

SITIO looks like a Dimension and if so won't work as you have found out.

[#3]

Count(SITIO)

[Anonymous]

You probably need to use the Aggr() function. 

Maybe something like this :

     Avg ( Aggr ( Count(SITIO] , FECHA ) )

[#5 · Accepted solution]

I found the answer!

count(SITIO)/COUNT ( DISTINCt  FECHA)

I think so! jaajajajaja