1 Reply Latest reply on Jun 27, 2012 2:45 PM by Tracy Rodgers

    Hoping for help - calculation on data from multiple sources

    Laura Seay
    Laura Seay Jun 27, 2012 1:02 PM

      I'm going to apologize in advance - this is my first time posting

       

      Working with multiple data sources – join is on Case Number

      1.       Dates are converted to “Float” to do logical comparison

       

      2.       pic1.jpg

      Co     Converted numbers are used in logical equation

      pic2.jpg

      3.       Field is displayed on worksheet

      pic3.jpg

      4.       Displayed totals.  When totaling, did not get the number I expected

      pic4.jpg

       

      DESIRED END RESULT:

      Sum (Anesthesia On-Time/Late – For Calculation)/ Count (Case Number)

      • 29 Views
      • Tags:
        • 1. Re: Hoping for help - calculation on data from multiple sources
          Tracy Rodgers
          Tracy Rodgers Employee Jun 27, 2012 2:45 PM (in response to Laura Seay)

          Hi Laura,

           

          This is because grand totals are not necessarily a sum of whatever is in the view, rather they use whatever aggregation is on the measure. So since the output of the calculation was to be either 1 or 0, the result was 1 because the total sum of Scheduled Date Conversion was greater than the Anesthesia Start Time Conversion. One way to get the desired result is to calculate the desired outcome and place it on a separate worksheet, then place these two sheets on a dashboard together.

           

          Hope this helps a bit!

           

          -Tracy