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
have you tried removing the group_by？
wanton7
Why do you have group_by there if you want to have average from all of them?
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
Marcus
Ah, ok. Have you tried Ecot.Query.subquery?
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Develop your skills with books, videos, and courses.
Categories:
Sub Categories:
Forums
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.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"