2 Replies Latest reply: Oct 31, 2014 11:00 AM by Karen Wallace RSS

    Help calculating some efficiency metrics - examples provided

    Karen Wallace

      Hello,

       

      I'm relatively new to Qlikview and wanted to see if anyone had thoughts on how to best measure the following (after trying several formulas and getting questionable results).

       

      We have a daily surgery dashboard that tracks information on many aspects of the operating rooms among our facilities.

       

      Surgeons have "block times" that are scheduled in advance for the given day and then we are looking at how closely they adhered to this time, so basically what is the scheduled (SCHED_START_TIME and SCHED_START_TIME) vs. actual time (PIR_DATE_TIME and POR_DATE_TIME)

       

      1. On the summary, I want a metric that calculates out of x number of blocks, the surgeons met this % of blocks successfully (stayed within their designated time frame).

       

      2. On the details, I want a metric that calculates yes/no as to whether the individual surgeon stayed within his block.

       

      I came up with the formula for #1 that is:

       

      SUM(If(PIR_DATE_TIME >= SCHED_START_TIME, 0, 1)) +

      SUM(If(POR_DATE_TIME <= SCHED_STOP_TIME, 0, 1))

       

      But it doesn't seem right...thank you in advance for advice!

       

      Regards,

      Karen