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,

      Santhosh