Help needed to create complex report with tables + charts similar to spreadsheet

I have many data types (finnancial data). I need to do calculation on them and create reports and charts. I am thinking to use JS/plugin to do the some calculation and save them to DB and do some on the front end for summation and for chart. If you have done complex financial reporting with many RG and charts with filters and with calculation in JS, I could use a consultation for your experience and best practices. :grin: Please DM me. Thanks.

1 Like

Hi @net-tt, how are you?

My team and I can definitely help you out with this one as one of my developers was in finance/accounting before becoming a developer and he also has create a JSON plugin and chats plugin that we could implement for you with all the calculations.

Feel free to reach out to me at info@nocodecreations.com.au or DM me here

Hey @net-tt I have a background in investment banking, venture-backed startups, and now running my own agency so I’ve worked on similar projects before and can help you with this. Let’s chat, I have sent you a DM!

Doing complex financial modelling in Javascript and or Bubble expressions quickly becomes very messy to maintain and debug - compared to what is easily achieved in a spreadsheet. And can consume a lot of WU to achieve what seem simple tasks on large datasets. There are only a handful of built in mathematical operators.

It is easy to create pretty interactive charts with ChartJS based plugins.

I’m trying to put you off :slightly_smiling_face: - just passing on lessons learnt. For a complex spreadsheet model with around 100 complex charts -
I ended up creating a macro to export the chart images out of excel, and passing the spreadsheet to AI to do narrative analysis and insight (amazing results) then combining this into a report in Bubble. The point of this app is to produce PDF reports - not an interactive app so may not be suitable for you - but some food for thought!

Good luck :slightly_smiling_face:

Thanks for the feedback.