Max date and corresponding measure for same set analysis

iParimal — Sat, 16 Nov 2024 03:05:54 GMT

Hi All

I have dimension and multiple dates with measure corresponding to them.

Need to calculate average in straight table . But should consider only latest measure based on date. Sample data and expected output given below.

Re: Max date and corresponding measure for same set analysis

rubenmarin — Thu, 04 Jul 2019 08:30:53 GMT

Hi, this result can be done in a table with Application_Name and Date as dimension and this expression:

Avg(Aggr(If(Date=Max(TOTAL<Application_Name> Date), Measure)
, Application_Name, Date))

Maybe you need to uncheck 'supress zero values' and use a calculated dimension to keep only the rows you want:

=Aggr(If(Date=Max(TOTAL<Application_Name> Date), Date), Application_Name, Date)