Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Currency Issue : Can't see revenue data in Rupees

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

When i change currency from GA admin panel it only change currency symbol .. and values remain same.. Please suggest how to change value as well as symbol to check data in Rupees

Re: Currency Issue : Can't see revenue data in Rupees = Money conversion

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

@Vivek G,
what you can do for this, this is to do the conversion with the values from Dollars to Rupees.

 

In Data studio, edit your data source. 

Duplicate your field Dollar to Dollar2 and set "none" in aggregation and "number" in type of your field Dollar

 

Create a field "Rupees" with the formula : Sum(Dollar/0.5)

0.5 is your taux conversion dollars/rupees (it's an example, i don't know the conversion)

When your field is created, change type of this field in "Currency rupees". 

 

You can see below what i did. 

Moneyconversion.PNG 

Currency Issue : Can't see revenue data in Rupees

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks Patrick..

But Dollar to Rupee conversion rate is not fixed.. It can change on daily basis. So I need this conversion dynamically not by a fixed formula.

It should be done through GA Admin Panel by currency setting.. but as i informed, it os only changing currency symbol not values.

Please help.