Dutch
Ecto query sum avg
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]?
Most Liked
princemaple
wanton7
wanton7
Then I don’t understand what is wrong because 1000, 3000, 1000 are averages per fizz_id?
fizz_id fizz_buzz
2 1000
2 1000
2 1000
= 3000 divided by 3 is 1000
3 3000
3 3000
= 6000 divided by 2 is 3000
4 1000
= 1000 divided by 1 is 1000
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.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Courses that'll move you from confusion to "Aha, now I get it!"
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #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.
Error tracking for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"