Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😊
Hi, maybe add additional aggregation by months too:
Sum(If(Aggr(Sum(Time),RS12Processes, your_month_field) < 85*[Process Time]/100 ,1,0))
Hi, maybe add additional aggregation by months too:
Sum(If(Aggr(Sum(Time),RS12Processes, your_month_field) < 85*[Process Time]/100 ,1,0))
Thankyou 😊