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.