Hi mates!
In some Bubble.io apps, we need to calculate the conversion rate of leads or other data. Today I will explain how to calculate the conversion rate of anything, especially in Bubble.io.
In my case, I needed to find the conversion rate of leads. In my Bubble.io app, I show this conversion rate to the sales user on their dashboard. As a Bubble.io developer, this is a very common requirement in SaaS and MVP projects.
The first thing is the database structure. If you have a different structure, no worries. The concept is the same for every Bubble.io app.
In my app, I have a Leads table. Inside this table, I have a status field where I store the lead status. The status values are “Pending”, “Won”, and “Lost”. I calculate the conversion rate based on the “Won” leads.
Here is the logic:
You need to search all leads with status “Won” and get their count. Then divide this number by the total leads count. After that, use Bubble.io’s formatted as expression and format it as a percentage.
That’s it 
Now you can easily show the conversion rate on the dashboard. This approach works very well in no code app development and is widely used in Bubble.io app development by Bubble.io freelancers and no code developers.
If you need any help, suggestions, or want a discussion with an experienced Bubble.io developer, you can book a free meeting using my Calendly link.