Data Analytics in Bubble

Hi all,

Is there any way for us to create data analytics in bubble ?

I am expecting an output as below:

  1. I want to create two tables at the Back-end having one similar column.
  2. Create another table in run-time by making those two previous tables as outer join (like SQL Joins) and retrieve the created table to a pie chart or bar chart so that we can input this chart to bubble application.

Please suggest me some ideas to handle with this task. All the inputs are appreciated.

Thanks.