2 Replies Latest reply on May 23, 2016 1:58 PM by msa s

    Multiplying Hourly Data in Two Tables

    William Kenworthy

      Hi, I have two data sets that contain hourly data.


      1.  Contains hourly data on electricity prices from 1/2/2008 (Just two fields, "Date and Hour Ending" and "Real Time Price")


      2.  Contains hourly kilowatt hours used for a home. (Also two fields "Date and Time (m/d/Y)" and "Upstairs kWH")

      Here's a screenshot of the data connection screen:



      I want to multiply the "Price" X "kWH" to be able to get graph hourly, daily, weekly and monthly total cost.


      I would appreciate any help.


      Thank You,