Minimum value for a range

[flemmingbj]

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 number	New value	Time
1	A	00:39
1	Ax	00:45
2	B	15:16
2	A	15:21
3	B	16:05
3	Ax	16:06
3	A	16:15
3	Bx	16:21

Expected output:

Incident number	Lowest value, A*
1	00:39
2	15:21
3	16:06

[jaumecf23]

Hi,

Try this:

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

[sunny_talwar]

May be with this

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

[flemmingbj]

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.

[sunny_talwar]

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?