Using set analysis to display max time

[#1]

Hi,

I want to display the Max created time by team in a text box

Team Name        Created Time        

Team A                 09:00                  

Team B                 09:00                   

Team C                 09:00                   

Team A                 10:00                   

Team B                10:00                   

So for Team A I would want to display 10:00. I've tried the below Set Analysis but it's obviously incorrect

=max({$<[Team Name]={$(=Team A)}>}[[Time created])

This is already working in a pivot table using this expression - =sum([Time created]*if([Time created]=aggr(nodistinct max([Time created]), [Team Name]),1,0))

I just want to replicate in a text box for a individual team.

Thanks in advance

[tresesco]

Try like:

=max({$<[Team Name]={'Team A'}>}[[Time created])

Single quotes around the field value. Note: You might have to format your output using time() around max().

[vinieme12]

as below

Team A =max({$<[Team Name]={'Team A'}>}[[Time created])

Team B =max({$<[Team Name]={'Team B'}>}[[Time created])

[Anil_Babu_Samineni · Accepted solution]

May be this?

=Time(Max({<[Team Name] = {'Team A'}>}[Created Time]),'hh:mm')

[#5]

Thanks very much for all your replies. That has worked perfectly.