Vizlib Table - display only certain rows...

[jerryr125]

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

[GaryGiles]

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.

[jerryr125 · Accepted solution]

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

Thank you for your help - jerry