Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Slice with daily min-value + daily max-value

i have a table with serveral datasets (rows) for each day

i need a slice with 2 datasests (rows) for each day:
a) 1 row with min-value of a specific numeric field for each day and
b) 1 row with max-value of the same numeric field for each day

i know that i can achieve Min- and Max-vaues with expression: MAXROW() and MINROW()

but i dont find a solution for selecting only 1 max-row and 1 min-row for each day …

many thanks in advance for your help.

Gottfried SUDI

0 12 373
12 REPLIES 12
Top Labels in this Space