topic Re: Utilization rate in QlikView

Utilization rate

ashrivastava — Mon, 03 Jul 2023 05:59:14 GMT

Hello,

I want to calculate the utilization of devices. The devices work for different durations based on the user. I have an end time and start time for every transaction on the devices.

I have calculated the interval for each transaction and can calculate the sum for a month. I want to divide this number by 10 hours per day of the month for monthly utilization.

How should I do it?

TIA

Re: Utilization rate

MarcoWedel — Thu, 06 Jul 2023 20:10:26 GMT

please post some sample data and your expected result.

Re: Utilization rate

ashrivastava — Fri, 07 Jul 2023 01:56:17 GMT

Thank you for the response. i have figured it out though.