topic Filter dimensions to only max date in App Development

Filter dimensions to only max date

johnnyjohn — Fri, 13 Nov 2020 10:08:23 GMT

I have the data show in the image. All my columns are dimensions apart from the very first one.

I need to filter the table so that each client (second column), only the information for the latest date is shows (the one underlined in red.)

How can I do this?

Re: Filter dimensions to only max date

GaryGiles — Fri, 13 Nov 2020 11:48:59 GMT

=Timestamp(aggr(max(Last_Execution_Date), Counterparty_Description),'DD/MM/YYYY hh:mm:ss')

Re: Filter dimensions to only max date

johnnyjohn — Fri, 13 Nov 2020 12:00:47 GMT

Thanks for the reply. However, when I try to add another column (here Quantity Available), I get multiple rows. I just need to get the quantity that was at the last time, i.e. 13204 was done as the Quantity Available for Actiam in the MAX time period, seen in the original question. How can I do this? Thanks