Blending three data sources with one of them having only a single value per key

Looker Q&A Looker Studio
1

I’m building a dashboard that blends three tables:

  • identifiers of athletes

  • db pulled from Strava: one row = one activity in a given time frame

  • manually tracked activity sheet: one row = kms for all the activities in a given time frame

The problem is that the one row with kms for all the activities in a given time frame gets multiplied by the count of activities pulled from strava, as it’s added to every single row of the blended data set.

Any ideas how I can make sure that sum of manually tracked kms is pulled only once and added to the total number of km pulled from Strava?

Many thanks!

2

It sounds like you may have joined table 3 to table 2 rather than to table 1! Try joining both tables to table 1, that might help your fanout.