Forum Discussion
Cumulative Totals by Group plus manipulation
Solution SageI 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.
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.