I am stuck up with a problem. I want to filter data from straight table based on some variable condition. Please see the attached file and suggest how can I achieve this?
Can you please look into the double clicking stuff?
I mean when you press COMPLIANT first time - it will show you all compliant but once you select NON-COMPLIANT it does not exclude the COMPLIANT stores - I tried the solution to select '*' before the actual SELECT FIELD check but even it is not working - we need to double click the button in order to apply the filter.
Yes I have also seen it not working. One potential solution is to create three tables one on top of each other which would always display either COMPLIANT or NON-COMPLIANT or BOTH at any given time. This would still be controlled by the two buttons. Does that sound like a possible solution?
Check the attached application out. There are three charts with conditional hide and show functionality based on the variable that is set by the two buttons.
This is fine but the functionality required is to filter the data. This is just a part of whole dashboard which needs to be updated/filtered according to the button selection.
Can we implement some macro based filtering for this scenario?
