I created a gauge to show the true error percentage. Employees are supposed to withhold 100% of the money in a system when clients are requesting a withdrawal from their bank account. But employees are not necessarily capturing this data and sometimes forget to enter that amount which doesn't freeze/hold that amount in the system.
So I created a gauge to show the error percentage rate to see how efficient the employees are capturing this data.
=(count({<[clientWithdrawal] = {0}>} [clientAccounts])) / (count([clientAccounts]))
When no value has been entered it will automatically be pushed as a '0'
So I want to count the client accounts with withdrawal amounts that are = 0 and divide that by the total client accounts existing. When I compare the results from the gauge and a simple check through excel I am getting 2 totally different numbers. My set expression looks correct, but hoping something is wrong at this point.
