Hi Everyone,
Could you please provide a best guide:
I am trying to find the lastest record my a history table. I have created a table with the necessary filters below:
i_Updated_On = maximum (i_Updated_On for i_WorkspaceID)
i_Updated_On <= _first_of_month (current_date )
I even tested it in a report so that when I apply them, I was able to find the correct record when these filters are applied at the query level.
However, when I apply these filters in a Dashboard either in the global filters or local filters I cannot obtain the correct results from a calculation using the resultant filtered records.
Not sure what I am doing wrong to obtain the correct records.
Mig
QuoteI was able to find the correct record
Why not? What was wrong? What is that you want us to fix for you...it's not very clear from what you've posted.