Cumulative Data with Delta

[Osirusblue]

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

[Anonymous]

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.