Consulting

Results 1 to 4 of 4

Thread: Using MINX for Fire Department Response Times

  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

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    24,908
    Location
    Any chance of posting a workbook with data loaded that we can play with?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    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

  4. #4
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,843
    Location
    C'mon guys. Keep it in the forum.
    Please take the time to read the Forum FAQ

Posting Permissions

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