Where cause in expression

[Anonymous]

Hi,

My current "working" expression: Avg([C_PR release time])

I however want to limit the chart to only show data for year 2016 so I tried the following expression:
Avg([C_PR release time]),[Year] ={'2016'}

Unfortunately I'm getting a message that there is an error in the expression.

[ali_hijazi · Accepted solution]

this is the correct syntax:

Avg({<Year={2016}>} [C_PR release time])

you need to read on Set analysis topic

[Anonymous]

Thx Ali. That's exactly what I was looking for.