I found a link to a waterfall report, and thought I’d give it a go. I’ve made a chart that easily shows all the transactions on an account with a clear visualisation of what the balance was after each transaction, with different colours to easily show payments/increases/etc.
The trouble I have is occasionally an account will have multiple transactions at the exact same time. I already have the X axis set as “Ordinal”, since it either doesn’t work (Internal Chart Error) when there are duplications, or it looks terrible if the account had say 3 transactions in a week and then another 2 years later.
So if the first two transactions in the table have the exact same time, I get a “Increase” column on my chart, which starts not at zero, but at a height of how tall it is.
That’s the initial balance being loaded and 2 payments, the green bars are perfect where they are, but the black bar should be from 0 to 1695, and really there should be a second black bar to show another increase. There doesn’t even seem to be an invisible “offset” bar under it.
These are the 4 lines that make up those 3 columns, where lines 1 and 2 have the same date/time