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 whole week
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
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.
2 Likes
Hello @ganihar !
Thank you for following up and sharing your solution!