Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ashrivastava
Contributor II
Contributor II

Utilization rate

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

Labels (1)
1 Solution

Accepted Solutions
ashrivastava
Contributor II
Contributor II
Author

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

 

View solution in original post

2 Replies
MarcoWedel

please post some sample data and your expected result.

ashrivastava
Contributor II
Contributor II
Author

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