Steps for updating the default currency
Turn on the Edit mode of your Looker Studio report. Click on the EDIT button on the top right of your report.
Now navigate to Resources -> Managed added resources -> EDIT
Click on Reconnect and continue.
Click on the drop-down arrow next to each field and choose the currency you want.
Click on Done.
Repeat steps 2 and 4 for the remaining data sources and click on close once done.
If the currency still does not change, try the below steps:Double-click on the metric whose currency you want to change. A new Chart menu will pop up on the right. Navigate to Setup>Metric and click on the small pencil icon.
Click on the Currency Type drop-down menu.
Choose the currency. You will now see the updated currency in your report.
Frequently Asked Questions (FAQs)
How can I convert different local currencies from European Amazon marketplaces (like Pounds, Liras, and Crowns) to Euro in Looker Studio reports?
To convert multiple local currencies to Euro in Looker Studio, you’ll need to blend tables with the appropriate exchange rates. First, convert all currencies to USD by dividing each value by the local exchange rate using the refdata_currency_exchange_rate table. Once you have the values in USD, add another exchange rate table to convert USD to Euro. This way, you’ll ensure consistency and accuracy in your report totals.
