Help with expression

[Anonymous]

please find the attached document .. can some one please fix my expression , i am unable to get the execution count value displayed for Task =  "client hub load" unless i select it .

Thanks

[Anil_Babu_Samineni]

May be this?

Only({<[Rum Metric Time] = {$(=concat( chr(39) & Aggr(Max([Rum Metric Time]), [Rum Task])  & chr(39), ','))},

[Rum Date]={'>=$(=Date(vRUMStartDate))<=$(=Date(vRUMEndDate))'}>} [Rum Execution Count])

[antoniotiman]

Hi,

Set Analysis is per Chart, not per Row.

Try

FirstSortedValue({<[Rum Date]={'>=$(=Date(vRUMStartDate))<=$(=Date(vRUMEndDate))'}>} [Rum Execution Count],-[Rum Metric Time])

Regards,

Antonio