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 year data (on the same date)

that way i can filter


1 Like