Difference between integers in a column

Follow
Anson Chan

Hello Team,

May I seek support on a case where I have 2 columns

- 1st column is the incremental dates

- 2nd column is the aggregated sum of a size

I tried to use GROUP_Previous to generate a new column so I can find the exact size of a particular day but the operation failed.

Can I receive your advice on what transformation operation I can follow to get to the result we need.

the outcome we looking for is a new column that provides the exact StorageBytes for that particular report_date.

 

thank you

0

Comments

6 comments

Date Votes
  • Konsta Danyliuk

    Hello Anson.
    What if you try the following approach.

    1. Add an index column to your source data. You could simply use an integer value, e.g. I've used 1.

    2. At the new Sheet group by this index via GROUPBY(#Source!Index).
    3. Then add the formula GROUP_DIFF(#Source!StorageBytes;0). The second argument of this function is optional and used as a result of the first record.
    4. Finally reference the date column. You might want to change the column order for convenience, e.g. I moved the report_date in front of the StorageBytesDifference.

    I hope this helps.

    0
    Comment actions Permalink
  • Anson Chan

    Morning Konsta - Gonna try it out and let you know asap!

    0
    Comment actions Permalink
  • Anson Chan
    • Edited

    Hello Konsta, I am able to follow your instructions, and reached to an accurate result.

    My final follow up question in this case is.

    How do I get rid of the first row? Without using any filtering options

    Thanks, Anson

    0
    Comment actions Permalink
  • Konsta Danyliuk

    Hello Anson.
    You could either create a new Sheet and reference only require columns or hide the column (header's right-click menu). I usually prefer the first option.

    0
    Comment actions Permalink
  • Anson Chan

    Hello Konsta, yes. I am able to handle the columns in a new sheet. I was referring to the first row where the Mar 10, 2021 row where the storage bytes difference is 0

    0
    Comment actions Permalink
  • Konsta Danyliuk

    Hello Anson.

    It seems I misunderstood your message. To remove the record, you could e.g. introduce a filter to remove all records where the StorageBytesDifference < 1. If you like, you could also use a second argument of the GROUP_DIFF function to set the desired value for the first record. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post