Filter Data in a Line Chart

[thrilos]

Hi,

I am working on Realease November 2019 and I am trying to filter my Line chart:

with this statement:

if (([Age) < '15' and [Number] = '1' , Avg([Weight]),)

but it does not work, for whatever reason. I also tried it with nested if's but it does not work also. Any ideas?

[tm_burgers · Accepted solution]

Would set analysis work:

avg({< [Age] ={">15"}, [Number] = {'1'}>} [Weight])

[PradeepK]

Avoid using if conditions.. Use Set Analysis

Avg( {< Age = {">15"} , Number = {1} >} Weight)​

Better Solution -> Move this condition to Script and create flag

if( Age > 15 and Number = 1, 1 ,0) as flag​

And in expression just write

Avg( Weight * flag )​