Anyone tried to create something similar to the waterfall chart in analytics? Basically the waterfall chart isn't loading as we have too many transactions and I need a breakdown of what the balance sheet number is.. any idea how this can be achieved?

you can replicate waterfall in Analytics but you definitely want to understand why your data is not loading in the native waterfall (revenue, correct?)

We've queried w NS support and the answer is there's just too many transactions to load the report... Checked if everything is being deferred and released etc... How can I go about recreating in Analytics... Any suggestions?

you can modify the native report limiting by certain criteria (your segmentation, maybe revenue account, item, customer, date, etc.). Yes, excessive number of transactions does cause the native waterfall to stop generating unfortunately

It's a bit of a minefield as we have a subscription model 24 months so it's quite difficult, hoping if recreated, analytics functionality will allow to load the data without timing out in comparison to the waterfall