I am looking at analyzing large data sets for completed jobs and calculating the utilization percentage each employee spent per day. This is down by counting up all of the minutes they reported as completion time and then dividing by the total number of minutes on the clock.
The problem is that the underlying system supplying the data allows for some strange results where jobs may take several days and this results in a comple of jobs each day that are 10,000 minutes. This obviously skews the data.
Is there any way that I can limit the loaded value in Qlikview? For instance, if the completed job takes over 180 minutes then the loaded value is limited to 180?
I am pretty sure that I am going to have to fix the source file, was just hoping their might be a more elegant way out.
