How to filter dashboard with count expression through an action button

[sjhussain]

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.

[andrey_krylov]

Hi, Syed, maybe this expression for button action would help

='("' & Concat( {<B_ISCANCELED={1}>-<IDENTITYNUMBER=P({<B_ISCANCELED={0}>})>}IDENTITYNUMBER, '"|"') & '")'

[sjhussain]

Andrey,

Thanks for the response.  I was thinking about the same but due to the fact that there are total of 60million records and filtered would be atleast 6 million records then this might pose an issue on the front end through the expression?

What do you suggest on large data set?

[andrey_krylov]

I'm struggling here. Does it take a long time?

[andrey_krylov]

OK, I'm not sure, but how about this scenario?

1. Selection -> Select in field            [B_ISCANCELED]            ->  0

2. Selection -> Select Possible            [IDENTITYNUMBER]

3. Selection -> Select in field          [B_ISCANCELED]      ->  1

4. Selection -> Select Excluded    [IDENTITYNUMBER]