4 Replies Latest reply: Jun 12, 2018 5:00 AM by Sunny Talwar

# Minimum value for a range

Hi

I want to find the lowest value of "Time" for a given Incident number, where "New Value" starts with "A"  and put it into a new variable in the example below. The number of rows per incident varies.

I have tried RangeMin, but can't make it work... Any suggestions?

Example:

Incident numberNew valueTime
1A00:39
1Ax00:45
2B15:16
2A15:21
3B16:05
3Ax16:06
3A16:15
3Bx16:21

Expected output:

Incident numberLowest value, A*
100:39
215:21
316:06
• ###### Re: Minimum value for a range

Hi,

Try this:

Date(min({<[New value]={"A*"}>}Time),'HH:mm')

• ###### Re: Minimum value for a range

May be with this

=Min({<[New value] = {"A*"}>}Time)

• ###### Re: Minimum value for a range

But this doesn't find the lowest value per incidentnumber but per row, so there will be multiple values per incident - one per row.

The min function should find the value within the range of uniqe incidentnumbers.

• ###### Re: Minimum value for a range

Not sure I understand, but are you having more than one dimension in your chart? I thought you only wanted Incident Number as your dimension?