Victor
Victor

Reputation: 1

Issue Calculating the Average of Consultants in Looker Studio

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.

dashboard consultores

Upvotes: 0

Views: 33

Answers (0)

Related Questions