Skip to main content
Topics#Tableau Desktop & Web AuthoringWill Kenworthy's Question
Will Kenworthy asked in #Tableau Desktop & Web Authoring
Jul 24, 2015, 7:14 PM

Sum of Interval Data for Previous "n" intervals

Hello, I have a data source with 15 minute interval data of electricity consumption.  It looks something like this:

 

DateandTimeKWH7/10/14 12:00:004567/10/14 12:15:004807/10/14 12:30:00475

 

The data set has one year's worth of this data.

 

I would like to sum the previous four days worth of intervals into a value. 

 

Thanks for your help.

2 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jul 24, 2015, 7:27 PM

    Hi William,

     

    I am not sure I understand your need. You want to sum the previous four days worth of intervals relative to what? Also if you can provide with a bit of more information along with what results do you expect to see, I am sure someone will jump in to help!

     

    Thanks,

    Pooja.

Write an answer...
0/9000