Consulting

Results 1 to 4 of 4

Thread: Using MINX for Fire Department Response Times

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Using MINX for Fire Department Response Times

    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
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •