Hi,
I’m trying to create a dashboard that will include a checkbox that when checked, will exclude all parts that start with a specific value.
Is that possible?
There are a couple ways:
- Customization that filters the data when the checkbox changes
- Make a field that provides a YES if the value exists for that row and then in the dashboard make a dropdown in the filters that has blank and YES as options.
I just had to do something similar. Another idea, may not be as clean, but it worked for me.
(1) In your BAQ create a subquery with Part and add a calculated field that if it starts with that certain value, have the value be “ALL”, otherwise have the value be “ALL-INCL”.
(2) Link the subquery to your main query and join on part number.
(3) In your main query add a criteria to the subquery on the calculated field that was added. have it set to “Matches” and create a parameter.
(4) Define a new Parameter and have the editor type as radio button. Create 2 values. Value for one of them will be ALL (With * on either side), and for the other it will be INCL (With * on either side). Add what ever display text you want.
Then when you run the query it will prompt you for either all the records, or the records excluding the values starting with the value. This at least solves the option of just having a check box and it is only showing the records that match that value, and never all the records regardless of the checkbox value.