Creating calculated metric based on blended data

0

I'm new to Google Data Studio and am having a problem with creating a calculated field from a blended data source. I created a blended data based on the sources with the following collumns: Table a: Date User name Sales (date) (text) (currency)

Table b: Date User name Duration of calls (date) (text) (number)

I join the data based on the date and user name. The metric I'm trying to calculate shall give me a duration/sales value. However, when I create a new metric usign the following formula: duration/sales. I am getting wrong number. Any ideas why this happens?

Thanks a lot for your help. Renat

Renat Ishmukhamedov

Posted 2019-08-30T19:22:48.333

Reputation: 1

1Welcome to Super User. All of the subjects associated with your question are off-topic on this site. If you hover on the tags, you'll see suggestions for sister Stack Exchange sites where this may be on-topic. Sorry, I'm not familiar enough with this to recommend which would be the best site. Perhaps another reader will be able to suggest the right site. Or check out Web Apps and Webmasters for similar questions, or post a question one one of the three Meta sites asking for advice on the best place to post. Good luck with this. – fixer1234 – 2019-08-30T23:01:27.140

No answers