Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
=Time(Max({<[Team Name] = {'Team A'}>}[Created Time]),'hh:mm')
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().
as below
Team A =max({$<[Team Name]={'Team A'}>}[[Time created])
Team B =max({$<[Team Name]={'Team B'}>}[[Time created])
May be this?
=Time(Max({<[Team Name] = {'Team A'}>}[Created Time]),'hh:mm')
Thanks very much for all your replies. That has worked perfectly.