when you say DATA IS GROUPED BY QUARTER, you mean on the right tables ?
I don't see wrong valus compared with your source..
Also, you can add this to your script to have the Weekdate and the Quarters, it will be easier to make the conditions on the expressions:
MakeWeekDate(Year,Week) as WeekDate,
'Q' & CEIL(NUM(MONTH(MakeWeekDate(Year,Week)))/3) AS CALENDAR_QUARTER
Thanks for your reply.
Yes the right tables are grouped for quarters. Please note that there is no dates used for identifying quarters, there is week number and have grouped weeks to categories quarters.
Data looks fine at glance but from Week 19(Quarter Q2 table) is wrong.
I am wondering may be because expression has above() and rangesum() its not picking right value. Can there be alternative way to group this weekly data for quarters.
If possible, Please check the app for variable and expressions.