I created a chart using WeekEnd(InvoiceDate) as the dimension and Count(Distinct ProductID) as the measure to see how many unique products are sold per week. Simple.
Now I want to know how many unique products were invoiced in a 12 week rolling period and report that each week. Essentially on the same chart add the unique count of products for the prior 12 weeks.
I have tried various rangecount, aggr, etc and cannot get it working. If only Rangecount had a distinct option.
Does any one have a suggestion on how to prepare that visual?
I use Henric's The-As-Of-Table for rolling period calculations. Your weekly count would be something like Count({<DayDiff={"<7"}>} Distinct ProductID) and the rolling 12 count would be Count({<DayDiff={"<84"}>}Distinct ProductID)
I use Henric's The-As-Of-Table for rolling period calculations. Your weekly count would be something like Count({<DayDiff={"<7"}>} Distinct ProductID) and the rolling 12 count would be Count({<DayDiff={"<84"}>}Distinct ProductID)
