I am facing a weird problem, i have created two calculated fields, one which gives me data for 2023 and one field utilizing the periodOverPeriodLastValue to give me data for 2022 (periodOverPeriodLastValue(sum({b2b_served_gms}), {time_period_value},YEAR, 1)).
I added both of these fields into values on a line chart with {time_period_value} in x-axis. Everything seems to be working perfectly fine if i have day/month level aggregation on time_period_value field. However, as soon as i change it to Week, the 2022 field vanishes. My hunch is that it has to do with week start/end date or something? Is there a way i can achieve what i am trying to do?