We have two interactive dashboard gadgets created in list view which shows sales orders and quotes. Once viewing the results in the gadget, one of the filter options is 'status'. We'd like to view 'Active' orders and quotes. but, filtering on 'active', 'Active', ' Active', etc, all return active and inactive records. I haven't been able to come up with a value that will return just the active records.
Does anyone have any suggestions or a workaround?