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")

      TableauScreenSnapz002.png

      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:

      TableauScreenSnapz001.png

       

      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,

       

      Will