1 Reply Latest reply on Jun 25, 2017 6:59 PM by lei.chen.0

    How to not return data if filter combos drop value under a threshold

    Andy Myers



      I have a dashboard which has 6 or so global, multi choice (number of choices vary from 2 -20 values), filters which control some table views with various metrics displayed.


      I would like to make it so that if a combination of filters causes a specific metric (lets say customers) to fall under 10, then either not show the tables (like it would if the combination choice did not return any data) or not allow me to make that combination selection.


      Obviously I could pre-filter the underlying data up front to only combos with >= 10 customers.  But with the sheer volume of combinations this would eliminate a considerable chunk of the data and hence the overall total numbers would be vastly altered.  Hence not a good solution.


      Any thoughts?  Thanks in advance