What I am saying is to give the percentage of total questions which has a Gscore of more than 7 for GRADE=SAFE. It works fine when I don't apply any filter.
However, I have a list box for Gscore, and when I select any value between 1 to 10, the needle in the gauge chart goes to >100%. When my condition asks to count only scores >=7, and if I select 4, the needle should go to Zero because 4 is not more than or equal to 7. I know I am doing something wrong because I am explicitly counting only >=7 but I can't figure out what.
What I wanted is that if I select any value from the GScore list box, the gauge should give me the right percentage. For example, if I select 3 in the Gscore list box, I should get 0 because it is less than 7. If I select 8, it should count only the 8s and give me the percentage.
Please help. Perhaps, I should remove "Grade='SAFE'" from the expression and use something like GetSelectedCount or something??