Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently have a chart which sums the number of hours assigned to a resource by week and applies a flag if the hours for the week exceed 5 (see below)
That I would like is a chart that only contains the week ending and the number of times that the flag has been breached that week. Using the above sample we would get the following result.
personnel_week_ending | total_breaches |
---|---|
2016-07-17 | 1 |
2016-07-24 | 2 |
Any ideas on the formula required to calculate the total_breaches expression while removing the resource_name dimension from the chart would be much appreciated?
Thanks for the reply Sunny that was close what actually worked was:
Sum(If(Aggr(Sum(hrs),resource_name,personnel_week_ending)>5,1,0))
see this
May be like this as your expression:
Sum(Aggr(If(Sum(hrs) > 5, 1, 0), resource_name, personnel_week_ending))
Thanks for the reply Sunny that was close what actually worked was:
Sum(If(Aggr(Sum(hrs),resource_name,personnel_week_ending)>5,1,0))
nailed it thank you