Display only lates date point on Spotfire

[maud villedey]

Hello,

I would like to display data labels on map charts. However, as I have data for different dates for each points (historical data), the map displays all the labels of all the historical data for one same point. I only want the latest data. How can I implement this I don't know how to set up filters for this, or if there is some parameter to tick in the map options.

 

Thank you very much,

 

Kind regards,

 

Maud

[Kirsten Smith (she/her)]

Try creating a new column that only has the current data in it. Something like:

 

case [Date] when (*current*) then [Date] else "" end as [NewDate]

 

then use the [NewDate] column for your labels.

[maud villedey]

Hello Kristen,

 

Thank you for your answer. I tried your code but it is not supported .. maybe there is an order difference For exemple I am not sure about what (*current*) is refering to ..

 

thank you very much 1

 

Kind regards

 

Maud

[Fabian Duerr]

You can think of *current* as the latest date for your category (your.unique.identifier).

 

So you should replace that with an expression that uniquly identifies the last date for every category.

 

So something like: *current* -> Max([Date]) OVER ([your.unique.identifier]), where your identifier could be based on multiple columns.

 

Or if you get new data every day: *current* -> Date(DateTimeNow())