4 Replies Latest reply: Sep 3, 2018 10:51 PM by Andrey Krylov RSS

    How to filter dashboard with count expression through an action button

    Syed Jawwad Hussain

      Hello,

       

      We have a expression with count and want to know how to select it and filter on the resultant IDENTITYNUMBER.

       

      count({<B_ISCANCELED={1}>-<IDENTITYNUMBER=P({<B_ISCANCELED={0}>})>}IDENTITYNUMBER)


      We want to have a button on which we click on the count number it will filter all the IDENTITYNUMBER according to the count.


      We know that it is possible through navigation extension in which we can define and ACTION.  What expression do we put in the action so that it filters the IDENTITYNUMBER.


      Also please note that there are about 60 Million records in he table so we are also looking for a solution which would be optimim in performance.


      Will appreciate some help.