Average headcount over a period

[#1]

Hi All -

Thanks in advance for your help!

I'd like to have 2 charts - one showing headcount for Jan, Feb and Mar.

The second showing average headcount for Q1.

I'm using this expression: 

= Count ({$<   STATUS = {"Active","LOA"}   > } DISTINCT EEID )

In chart one, i'm using dimension = month (e.g. 01/01/12)

In chart two, i'm using dimension = quarter(e.g. 2012Q1)

In chart one, i'm using the 'average' plot for trend.  I want this same value showing in chart2.

How do i do it?

See attached pic for more clarity.  Thanks!

Pat

[goldnejea8 · Accepted solution]

Try using the aggr() function.  Then you can get the average over a period of time.

AVG(aggr(Count ({$<   STATUS = {"Active","LOA"}   > } DISTINCT EEID ) ,Month))

[#3]

Worked like a charm.  Thanks!

[goldnejea8]

Excellent, glad to hear!