topic How to filter dashboard with count expression through an action button in App Development

How to filter dashboard with count expression through an action button

sjhussain — Sat, 16 Nov 2024 07:43:29 GMT

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.

Re: How to filter dashboard with count expression through an action button

andrey_krylov — Mon, 03 Sep 2018 19:51:01 GMT

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

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

Re: How to filter dashboard with count expression through an action button

sjhussain — Mon, 03 Sep 2018 19:53:16 GMT

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?

Re: How to filter dashboard with count expression through an action button

andrey_krylov — Mon, 03 Sep 2018 20:08:37 GMT

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

Re: How to filter dashboard with count expression through an action button

andrey_krylov — Tue, 04 Sep 2018 02:51:14 GMT

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]