Circular Chart with data from same row

Looker Q&A Looker Studio
,
1

Hi, I have a Looker Studio report that is connected to a Google Sheet. In that Google Sheet I have a table with Year, Total Deposit, Anual Interest and Balance columns. Balance equals the Total Deposit plus the Anual Interest.

I have a Table that shows all these data, and when I filter a Year, I want to know how much of the Balance is Total Deposit, in percentage, and how much is the Anual Interest, in percentage, and all of that in a Circular Chart. For example, if in year 5, the Balance is $1000, and Total Deposit is $750, and Anual Interest is $250, I want a Circular Chart that shows me, Total Deposit 75% and Anual Interest 25%. And I don’t know how to do it. I’ve tried multiple things but nothing has worked so far.

If someone knows how, I would appreciate the help. Also, I am new to Looker Studio.

Thanks in advance!!

2

Hi @jalsinafm , thanks for your post, and welcome to Looker Studio!

If you’d like to create a pie chart with your data, the Pie chart reference is a great resource that can guide you through creating the chart that you’d like. The reference page also has links to other pages for certain steps, like connecting to a data source, and best practices for configuring the data for the pie chart.

There are other helpful resources for getting started, like the Create a Google Sheets data source tutorial, Add charts to your report tutorial, and Create calculated fields in Looker Studio tutorial.

This Community is also a great resource - you can search for similar topics that others have collaborated together on, and other helpful solutions and tips!

1 Like
3

Thanks, I’ll take a look. Thank you very much!