Reputation: 1
I need to calculate the overall average of consultants in a spreadsheet, but the average in Looker Studio is coming out wrong. I’ve tried everything, but it’s still not working. I already have the average per consultant, but it doesn’t work when I try to calculate the overall average from that sum.
What I need is to show only the overall average (month/year) on the dashboard, without displaying the individual consultant averages. The data in the spreadsheet looks like this:
Here is the structure of the spreadsheet:planilha
Can someone guide me on how to calculate the overall average for the entire month, excluding individual consultants?
Average of Consultant Scores:: SUM(Pontos diarios / COUNT_DISTINCT(EXTRACT(DAY FROM Data))
Daily Points: CASE WHEN Realizado = '✔' THEN Nota final ELSE 0 END
Final Score:CASE WHEN Realizado = '✔' THEN Peso WHEN Realizado = 'Sim' THEN Peso ELSE 0 END
These formulas return the average per consultant, but they do not return the overall average when excluding individual consultants.
Upvotes: 0
Views: 33