Help calculating some efficiency metrics - examples provided

Thu, 30 Oct 2014 21:11:18 GMT

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

Re: Help calculating some efficiency metrics - examples provided

Gysbert_Wassenaar — Fri, 31 Oct 2014 11:02:42 GMT

Can you upload a sample document with relevant data? See this document in you're worried about confidential information: Preparing examples for Upload - Reduction and Data Scrambling

Re: Help calculating some efficiency metrics - examples provided

Fri, 31 Oct 2014 15:00:22 GMT

Thank you for that information, Gysbert.

topic Re: Help calculating some efficiency metrics - examples provided in Water Cooler

Help calculating some efficiency metrics - examples provided

Re: Help calculating some efficiency metrics - examples provided

Re: Help calculating some efficiency metrics - examples provided