topic Re: Minimum value for a range in App Development

Minimum value for a range

flemmingbj — Mon, 11 Jun 2018 15:28:41 GMT

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

Re: Minimum value for a range

jaumecf23 — Mon, 11 Jun 2018 16:04:29 GMT

Hi,

Try this:

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

Re: Minimum value for a range

sunny_talwar — Mon, 11 Jun 2018 16:05:07 GMT

May be with this

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

Re: Minimum value for a range

flemmingbj — Tue, 12 Jun 2018 07:00:53 GMT

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

sunny_talwar — Tue, 12 Jun 2018 09:00:19 GMT

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?