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

    3563958

      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