PDA

View Full Version : Sleeper: Using MINX for Fire Department Response Times



bvanscoy678
08-17-2014, 05:47 AM
I"m using the below formula to find the fastest response times to a fire alarm.


=CALCULATE(MINX(apparatus,[RoundResponse]),
FILTER(uv_901ACTION,uv_901ACTION[Top_Category]="Fire"),
FILTER(apparatus,[RoundResponse]>1),
FILTER(incident,incident[priorityresponseflag]=TRUE()),
FILTER(uv_901APP_TYPE,uv_901APP_TYPE[Description]="Engine"))

The apparatus table contains each units response and it has a relationship to the incident table that has just one incidentkey per call.

I tried the logic of counting the rows of the incident table where the response time was <320, but it returns the same number in the pivot all the way down.


=CALCULATE(COUNTROWS(FILTER(incident,[CalculateRound Min Response Time]<320)),
Filter(uv_901ACTION,uv_901ACTION[Code_Category]="1"))

I'm a bit lost and would appreciate any ideas or help.

Thanks, Brent

Bob Phillips
08-18-2014, 12:42 AM
Any chance of posting a workbook with data loaded that we can play with?

bvanscoy678
08-18-2014, 06:28 AM
I tried to post a link, but I don't have enough post on the forum to allow it.
I've modified the original content to cover about 14 days. If you send me an email, I'll send you the workbook.

bvanscoy678 at gmail.com
Thanks for looking. Brent

SamT
12-06-2014, 12:52 PM
C'mon guys. Keep it in the forum.