Max values/dates in Filters

Question

Jeffrey DiLiddo · Nov 25, 2019

Hi All - Been looking in the documentation to see if, in DeepSee->Analyzer there's a way to create a filter on the "Most" recent date in a dimension. The filter affords the ability to choose "Now" but sometime the most recent date in the data was a week ago.

Discussion (1)1

Peter Steiwer · Nov 25, 2019

Hi Jeffrey,

I think the best option here is to use the TAIL function. Please see the documentation for implementation details.

An example from the HoleFoods Sample:

Peter

1 0