Forum Discussion

AUGUSF's avatar
AUGUSF
New Member
8 years ago

Cumulative Totals by Group plus manipulation

Hello,   I've been struggling with my data to get what I need, I could solve some of the problems, but couldn't put everything togheter:   I have 7 meters which record data every 15 minutes, I ha...
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
8 years ago

I would be helpful to either showed desired ouput or provide a sample file for someone to look at.  It's not clear what your current data model structure is or what desired output is.

  • AUGUSF's avatar
    AUGUSF
    New Member
    8 years ago

    Hello mattbrice, thanks for your reply.

    This is what my source looks like, they came from an ODBC server:

     

    "SourceID" is the meter code, which I first stated as A, B, C.. And "Value" the cumulative readings, the numbers seems weird because this particular meter (8406) is not calibrated yet, but assume it's a cumulative column over time.

     

    I want my output to be what was read by each meter in a given period of time, then I should add or subtract some of them togheter to get the mass balance right as in C1, C2, etc.

    I don't know if it's better/possible for my output (C1,C2...) to be a colum or a measure. I want the total daily value of Cn and plot it's value hourly.