There might be some simple explanation but i cannot figure it out.

  • ArtVandelay@lemmy.world
    link
    fedilink
    English
    arrow-up
    23
    arrow-down
    1
    ·
    edit-2
    8 months ago

    Data scientist here! What you have discovered is what’s known in data analytics as a semi-additive measure. Instead of summing the balance column, you would count it, and get a measure that showed how many transactions took place, but not a balance. Of course, there’s no reason to simply count the one column, a row count would suffice and return the same.