Forum Discussion

pzeller's avatar
pzeller
Frequent Visitor
9 years ago

Page Level Filter by Max Date - Direct Query

We are trying to create a page level filter on the MAX(Date). By default the page level filters do not have the "Latest" filter like when you're creating a card visual. We have tried creating a MEASU...
Need Help
parry2k's avatar
parry2k
Super User
9 years ago

Latest date is always today's date or latest date is based on the last record in the table, please clarify?

pzeller's avatar
pzeller
Frequent Visitor
9 years ago

parry2k, actually neither. "Latest" means the most recent date in the date column. It will not always be today and the records may not be in order so it can't be the "last" record. It should be equivalent to MAX() or LATEST() in terms of a datetime.