This content has been marked as final. Show 2 replies
Create metric with expression max(calendar_dt)
and to that metric properties->Content tab->Select day dim at All or the top most level.
Add this metric to report, use Narrative view call it @1 assuming #1 position from left to right in criteria tab.
When you are adding this to page select Narrative view.
If helps mark
You really like taking the hard road which generates unnecessary SQL, do you. What's wrong with a simple and easy dynamic repository variable?!
If you refresh that once an day after the ETL has run, it's 1 SQL execution. Once an hour is 24 SQL executions. Do it your way = one SQL exectution every single time the object is called. Multiply that by use cases. If you include that in mulitple dashboards/pages/whatever, the number just soars.