Now that we have our calculations seemingly correct, it is important to take a closer look so that we can discover any anomalies or instances that might throw off the calculations.
Checking and troubleshooting calculations
Boundary cases
A common method of performing checks is to look at boundary cases, or the maximums and minimums of our calculations. To do this, follow these steps:
- Start by clicking on the %Utilization column header in our table visualization. This sorts the table in descending fashion, where our highest %Utilization number is at the top of the list. We can see what might be some anomalies of very high utilization, such as the %Utilization at the top, which has 175% for Cole, Camille.
- To check...