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

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

is it possible to create a calculated field as calculation between fields from different data sources?

For example: "new_field = (field_1)/(field_2)",

where "field_1" comes from Analytics data source and "field_2" comes from MySql data source.

 

Thank you,

Massimo

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Massimo L
April 2017

Calculated fields from different data source.

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Unfortunately, no, you can't mix data sources. 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Massimo L
April 2017

Calculated fields from different data source.

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Unfortunately, no, you can't mix data sources. 

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Is it possible to mix the data-source now?

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I have exactly the same problem. It's such a basic feature for any visualisation platform.

Alternatively, you can use third-party solutions like supermetrics to link multiple data sources to google sheets and make the calculation there. Afterwards you can use the calulculated google sheets data in data studio.

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

You can solve this situation with a third party tool as Supermetrics or Funnel.io.

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Thank you, I'm aware.

You can swim trough the ocean too. But its easier to take the plane.