Limiting data using expression - with a date

A quick tip on using a date to limit data in a visualization with a date.  I found this non-intuitive and undocumented.

This syntax for the boolean expression using a date works:


Interestingly, Date() is not a documented function in the expression builder.

You may also wish to create a document property for your date rather than hard coding a single date.

I created a document property called ViewDate.

To filter data in my visualization to the value of this property, I used the boolean expression


[SnapshotDt]=${ViewDate} does not work!

PS - I am on version 4.0.


Image icon limitDataUsingExpression.png39.49 KB

(5) Answers