Get values for max Date

[xyz2]

Hi,

I have try to solve following problem:

In the app, i have different visualizations which are presenting my data. Additionaly, i have a table which shows the detail information of the visualizations.

Since i have a time course in my app, but want to show in the table just the data of the current day, i insert following formula:

{$<[Created_Date]={'$(=max([Created_Date]))'}> }[ID]

My data looks like that:

ID	Created_Date
89237	2022-09-15
93283	2022-09-14
94566	2022-09-01
94972	2022-09-01
97473	2022-09-01
99736	2022-09-01

But with the formula it doesn't show me the IDs of the current (max) day. It presents everything to me.

So what can i do to make my table only show me the data for current day?

Thanks in advance!

[martinpohl]

on the bottom of the expression editor, you can see the result of your calculated expression in set analysis.

Please check, maybe the date-format is incorrect, resulting on max-expression (could be a daynumber-format)

Regards

[xyz2]

In the results its shows me the correct date (2022-09-15) and i expected to only see ID 89237. But actually it shows me all six IDs.

I think that's because of the time history, because when I'm in the view and select the current date in the time course, I see IDs of the day, otherwise I see everything.

[martinpohl]

is the posted expression the complete expression?

Please change to 

max({<[Created_Date]={'$(=max([Created_Date])}'}>} ID)

and if nessesary, change type from dimension to expression

Regards

[BrunPierre]

Probably this

Max({<Created_Date={"$(=Max(Created_Date))"}>}ID)

[xyz2]

The complete expresion is:

{$<[Created_Date]={'15.09.2022'}>}[ID]

When i change it to your formula i get following expression:

Error in formula
max({<[Created_Date]={'${(=max([Created_Date])}'}>} ID)

(But i doesn't tell me, why i have an error)

How do i change the type from dimension to expression?

[xyz2]

This also don't work for me. In the editor it says, that the formula ist "OK" but i don't get any data returned.