How To separate AGGR sums by month for a line chart

[James_B]

Sum(If(Aggr(Sum(Time),RS12Processes) < 85*[Process Time]/100 ,1,0))

above is the expression I used to tell me how many jobs are under 85%  when I select the month from the filter.

but when I use this expression for my line chart for a monthly update it sums for the whole year and doesn't break it down by month.

how can I fix this issue? 

Please help 😊

[justISO · Accepted solution]

Hi, maybe add additional aggregation by months too:

Sum(If(Aggr(Sum(Time),RS12Processes, your_month_field) < 85*[Process Time]/100 ,1,0))

[James_B]

Thankyou 😊