Display Shortest & Longest Project Duration

[Anonymous]

Hello - 

I'm working with a large time entry data set. I'm looking to show 2 cards, 1) with the shortest project duration and 2) with the longest project duration. 

What is the best way to show this? 

Thanks in advance,

Matt 

[Anonymous · Accepted solution]

Hi

Create 2 new measures

Shortest_Duration = MIN(Proj_duration)

Longest_Duration= MAX(Proj_duration)

and place them on 2 cards.

Thanks

Raj