Questions 1. Is the above correct syntax or is there a better way of calculating my compliance rate?
I also have a table with various departments. When I select a specific department, the gauge meter will return the compliance rate for that department (which is good).
However what I am trying to do is to have another gauge meter set to a specific department, so I can compare the specific department versus the overall compliance rate on the screen.
Basically have the 1st gauge meters for overall department and the 2nd for a specific department, and I really would like that when I select a different department it would only modify the 1st gauge meter and leave the 2nd set to only the specific department.
Question 2. Is the above possible if so, can you please help
(also I really would like not to use the bookmark feature if possible, and currently I cant import any extensions into Qliksense).
You may want to consider counting Account IDs (assuming it is unique for each account) rather than the explicit Yes or No values. Overall this is a better data structure practice and will give you more flexibility as your app grows in complexity and will account for null values and ones that are neither Yes/No in the [Account Compliant] Field.
For example your first chart (the one that doesn't change based on department) might be: