Forum Discussion
Helper IAdWords avg. position calculation
Perfect, I created a column using this formula:
WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
I also created a measure like this:
mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])
Community ChampionSeems like a straight-forward calculation, what kind of error are you seeing? Any chance you can post sample data?
Helper IHey smoupre! Thanks for answering the call!
What sort of data do you need? Here is a screenshot of the table I am trying to plug this as a Mesure:
If you need anything else let me know! More than happy to supply!
- Greg_Deckler
Can you post that in text so that I can copy and paste easily into an Enter Data query?
- dyingod
Hey!
Is this better? I exported some of the data from the table I'm using.
https://docs.google.com/spreadsheets/d/1msWrta5KOl1SsnC5sqIU2yOlBHDAlkr2zOWQ4TQLIvE/edit?usp=sharing
- Greg_Deckler
Perfect, I created a column using this formula:
WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
I also created a measure like this:
mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])