How do I do an average of all values for an individual user?

Queries and Resources
1

I have an internal dashboard where data is pulled from an external source. The data will pull the employee that completed the task, along with some data about their efficiency.

How do I calculate an average of all values for an individual user, similar to =AVERAGEIF or a PivotTable on Google Sheets or Excel, and then display the averages for each user (with each user's name only repeating once) in a table?

2

Hey @orionreynolds1,

Not entirely sure what kind of data you have but you can use Query JSON with SQL here with something like this:

SELECT
  u.name,
  AVG(u.value)
FROM {{ yourQuery.data }} u
GROUP BY u.id, u.name

Notes:

  • u - being an alias for your data
  • u.id - being the primary key in case you have non-unique first name
1 Like