Dutch
Hello, all! I have a noob question about ecto.query.
Table:
Fuzz
fizz_id fizz_buzz
2 1000
2 1000
2 1000
3 3000
3 3000
4 1000
Take a look:
Repo.all(
from(n in Fuzz,
group_by: n.fizz_id,
select: avg(n.fizz_buzz)
)
)
The result that I get is [1000, 3000, 1000]. Can I get with query the result that I really want. In that example [1667]?
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ai
- #ecto-query
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Producing high quality Elixir screencasts since 2017.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Most Liked- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
princemaple
have you tried removing the
group_by？wanton7
Why do you have
group_bythere if you want to have average from all of them?wanton7
Then I don’t understand what is wrong because
1000, 3000, 1000are averages per fizz_id?Last Post!
wanton7
Ok so you need average of averages. I haven’t used Ecto a lot and I’m not sure it supports select from select because it has to support range of databases. Inner select would be this query and outer select would return average of it. You might be able to solve this with a fragment of raw SQL. Or if there aren’t that many averages returned by that Ecto query you can always just use ä Elixir code to calculate that last average.