How to count weekly average points from tasks resource? defmodule Ash.Assignments.Milestone do ... attributes do uuid_primary_key :id attribute :title, :string attribute :description, :string attribute :due_date, :utc_datetime timestamps() end relationships do has…

I would write a custom expression for a start_of_week and end_of_week or similar. See: Ash.CustomExpression — ash v3.29.3

Sure I will try CustomExpression and let you know.

Is the idea that start_date and end_date are provided when asking for the avg story points for the week? Or does that just mean “this current week”?

Gotcha, then yeah a custom expression, or a fragment, or lazy would work. i.e fragment("postgres_code_that_gets_you_start_of_week") or lazy({SomeModule, :start_of_week, []})

Elixir Programming Language Forum

Aggregate the average story point for the week

Questions & Help Questions

Sakthibalan March 13, 2025, 9:39am 5

Yes, just I need the current week.