I am trying to display the quantity value that was of last day of the week. For ex my quantity was 95 on last day of last week i.e 05-10-2024. But I want to display this at a weekly level without summing the quantity of the whole week. Week-40 Qty - 95 instead of Week 40 QTY - sum(qty) of the wh…

I resolved using this solution - sumOver(ifelse({reporting_date} = maxOver({reporting_date}, [{reporting_week}], PRE_AGG), {qty}, 0), [{reporting_week}], PRE_AGG). This was suggested solution in another thread.

Lastvalue for Weekly,Monthly grain

Question & Answer

duncan October 10, 2024, 5:55pm 2

Hello @ganihar !

Could you share an anonymized version of your dataset? That would help me understand what functions might need to be used to make this work.

Alternatively you could create an arena link:

1 Like