1 Reply Latest reply on Oct 9, 2017 6:27 PM by Thomas Dodds

# Selecting values at timeperiod when sum of all values is highest

I am having trouble selecting the maximum occupancy values in a specific time chunk, when I have multiple units.  My data is stored in 15 minute intervals, and I want OBIEE to return the values for each hour when the sum of the patients in all three units is highest.  When looking at the table below, the highest total is 102 @ 1:15. so I want OBIEE to return the vales of each unit at 1:15. (A=100, B=2, C=0)

When using the code below, and it returns the highest patient occupancy each unit had individually during the hour.(A=100, B=50, C=30)

MAX("Snapshot"."Patients"  by "Snapshot Date"."Date", "Snapshot Date"."Hours", "Area"."Unit Names")

How do I get OBIEE to return all the values at 1:15? (A=100, B=2, C=0)

Patients/Time1:001:151:301:45
Unit A

0

1003520
Unit B5025015
Unit C100030
TOTAL6010285

65

• ###### 1. Re: Selecting values at timeperiod when sum of all values is highest

you need a level based measure (total across all details/units) by time slot ... then select max.