8 Replies Latest reply on Jun 30, 2014 6:02 AM by Prashant Sharma

    bottom N with a condition

    santhosh krishnan

      Hi All,


      I need to get the bottom 5 by a certain metric( I am aware of the filter->bottom 5 option).

      (lets call this metric1)

      However, I need to do this with a filter of NON-ZERO values by a certain other metric (metric 2, say). I tried including this in the "Flter-> condition" part but that didn't work.


      Anything I am missing here?


      I have attached 3 screenshots:


      1-  The condition by metric 2

      2 - The bototm 5 filter by metric 1

      3-  The resultant "filter"


      Thanks in advance,