Year ON Year Sales

[ErikG]

and i posted something similar here →

Navigation action using date parameters

Hi @Mardcp recently i did something like periodOverPeriodDifference(sum(ifelse({date_ordered}>=parseDate(concat(toString(${ComparisonYear}),"/","01","/","01"),"yyyy/MM/dd") AND {date_ordered} <= parseDate(concat(toString(${ComparisonYear}),"/",toString(extract("MM",${ReportingDate})),"/",toString(extract("DD",${ReportingDate})),"yyyy/MM/dd")),measure,0)), {date_ordered}, WEEK,53)*-1, to show the PY data on the same dates as the selected year. so green is the current year and gray the prev ye…