topic Vizlib Table - display only certain rows... in App Development

Vizlib Table - display only certain rows...

jerryr125 — Sat, 16 Nov 2024 00:42:07 GMT

Hi -
I have a #VizLib visualization - table - in which I would like to do the following

1. I have a variable (vCountDate)

Count({<[REQUESTDATE]={">=$(=Date(Max(REQUESTDATE)-9))<=$(=Date(Max(REQUESTDATE)))"}>} [REQUESTDATE] )

Therefore the variable is equal to '1' or '0'.

2. In the VizLib table I only want to show rows in which the vCountDate variable is = 1. For some reason I cannot figure this out.

Thoughts ? Jerry

Re: Vizlib Table - display only certain rows...

GaryGiles — Tue, 02 Feb 2021 22:13:06 GMT

1. I'm not sure how your expression yields a 1 or 0. It looks like it would yield however may REQUESTDATEs betwen max(REQUESTDATE)-9 and max(REQUESTDATE). I'm assuming that if it returns >0, then it is considered a 1.

2. What dimensions will you be including in your function? I think you will need to use an aggr function, something like:

=if(aggr($(vCountDate), DimensionName)>0,DimensionName)

There might also be a way to use the P() function to accomplish your desired results.

Re: Vizlib Table - display only certain rows...

jerryr125 — Wed, 03 Feb 2021 08:40:25 GMT

Hi - I was able to filter out the table via a dimension...works perfect now.

Thank you for your help - jerry