Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Display Shortest & Longest Project Duration

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 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

    Create 2 new measures

     

    Shortest_Duration = MIN(Proj_duration)

    Longest_Duration= MAX(Proj_duration)

     

    and place them on 2 cards.

     

    Thanks

    Raj

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

    Create 2 new measures

     

    Shortest_Duration = MIN(Proj_duration)

    Longest_Duration= MAX(Proj_duration)

     

    and place them on 2 cards.

     

    Thanks

    Raj