get number of orders per store per week in buckets

[Stephen_Theunis]

Hello,

I want to get the number of orders per store per week in buckets, using dimensions: week, store_id and measure: orders.

Currently, 1 row shows the week, the store_id and the number of orders for that week and store. Now I want to count how many stores have less than 50 orders per week, how many have between 50-100, and how many have more than 100 orders per week.

For instance, week 1 had 32% of stores with less than 50 orders per week, 40% between 50-100, and 28% > 100.

This article suggested to build an NDT to convert the measure of orders to a dimension, after which I can create the buckets. However, my original data is on day level, so I already need to build an NDT to get the measure on week level per store, so that would require me to build an NDT based on an NDT. Is there another way of doing this?

Many thanks,

Steve