topic Re: Table Visualization - show most recent date in App Development

Table Visualization - show most recent date

jerryr125 — Mon, 20 Dec 2021 21:02:46 GMT

Hi -

I have the following Table visualization:

I would like to Table visualization to only display the most recent date by location.

Therefore, given the example above, the visualization should display the following:

thoughts ? Thanks - Jerry

salonicdk28 — Thu, 11 Mar 2021 13:57:50 GMT

Try this-

Dimension- Location

Measure-

Date=Date(Max(Date))

Quantity=FirstSortedValue(Quantity,-(Date*1000+Quantity))

jerryr125 — Thu, 11 Mar 2021 15:20:16 GMT

Hi that did not work unfortunately - It is still displaying multiple dates for each location.

salonicdk28 — Thu, 11 Mar 2021 15:24:55 GMT

You just need to take only Location as Dimension and other 2 fields will come in expression

1) Date should be calculated in expression as Date(Max(Date))

2)Quantity=FirstSortedValue(Quantity,-(Date*1000+Quantity))

Please try this way, Hope you get the result