I am planning to use bubble as client portal for my clients. I have client table(ID, Name, etc.); Clients Transactions Table(Product, number of shares, date of transaction) and Products Share Prices Table(Product name, Date of evaluation, Price per share). From this data I want to create a chart for Clients which is going to have dates on X axis, and their value of assets on Y axis.(Value of assets being: number of shares multiplied by corresponding share price for that period). How should I approach this? Do I need to calculate balance for every client separately and have a large data base or is there any other way?
Forum
Academy
Marketplace
Showcase
Pricing
Features