Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I need to assess if a breach has occurred or not occurred on a day. There are a number of variables processed each day, if only one of them Breaches I need to count that as the breach for the day, ie. 1. It is a binary solution, if it is not a breach it must have been ontime. What I attempted to do with the formula is find the minimum of minutes for the day based on the unique ID which is the feedId, and if less than 0, Breach, if not Ontime.
Count(
aggr(
if(
min(Total <Status,Category> Minutes)<0,'Breach','Ontime'
)
,Status,Category,Minutes
)
)
In the screenshot below the Count for day should be 1 for Breach and 0 for Ontime
Try below
Pick(Match(Status,'Breach','Ontime')
,
Sum(AGGR(if(min(Total <Milestone> Minutes)<0,1,0),Milestone))
,
Sum(AGGR(if(min(Total <Milestone> Minutes)<0,0,1),Milestone))
)
That did not work. It needs to work on a consolidated basis as well, there are 18 days that were either in breach or not that is not occurring. If I choose one day it should be either in breach or not for category = source so 1 or 0.
This is how it should look like. This report is already at an aggregated level from the DB, I want to aggregate in Qlik from detailed information.
This is how it should look when I choose one day.