topic Re: Where cause in expression in App Development

Where cause in expression

Anonymous — Thu, 02 Mar 2017 07:59:12 GMT

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 — Thu, 02 Mar 2017 08:20:42 GMT

this is the correct syntax:

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

you need to read on Set analysis topic

Anonymous — Thu, 02 Mar 2017 13:41:14 GMT

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