Forum Discussion

Osirusblue's avatar
Osirusblue
New Member
2 years ago

Cumulative Data with Delta

Hello, I'm trying to build out some visuals from a query that returns work id, completed work, and date [weekly]. Word IDs can span multiple weeks. What I need is the first completed work amount per work id [earliest week value for that ID] and then against that same work ID for each subsequent week add only the delta to the first value. I'm sure there's a more logical way to get what I'm after but I'm so new at this whole thing. These individual IDs then group up into a separate Project level ID. So multiple IDs in this data set will have hour totals that connect.

Example:

 

In the visual I'd want a per week value not a total cumulative value, 12/2 would be 16, 12/9 would be 46 etc. against this massive 10k lines data set. Any help would be appreciated

General Comment
Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Osirusblue ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

     

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.