How to SELECT COUNT, SUM in one query?

Ash Forum Ash Questions / Help
,
1

How to write an action to run the following query?

SELECT COUNT(field1), SUM(field2) FROM table WHERE field3 = value;
2 
Resource
|> Ash.Query.filter(field3 == ^value)
|> Api.aggregate!([{:foo, :count, field: :field1}, {:bar, :sum, field: :field2}])
#=> %{foo: 10, bar: 25}
3 Likes
3

Thanks, Zach.