Hello,
I am building a filled gauge card where I would like to show as a maximum value the total number of members in a gym and, as the current value, the number of those members who are using a training plan. The problem is that I also need to include a few filters (to exclude employees and inactive members for example), so when I try to set as COUNT(member_id) as target value, those filters are also applied to the target value, actually making it match the current value. Is there a way to override those filters for the target value or of using a beast mode calculation such as COUNT(member_id) to set the maximum value?
