Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a large data set; about 50k rows. The data includes customer, product model and the number of each product bought by customer. My challenge; i would like to create categories based on the volume of products bought by customers. For example:
> 1000 units
500-1000 units
250 - 500 units
100 - 250 units
50 - 100 units
25 - 50 units
10 - 25 units
5-10 units
< 5 units
do you have any sample data
An calculated dimension like this:
Count(Aggr( If(Sum(Qty) > 1000, Dual('>1000', 1000), If(Sum(Qty) > 500, Dual('501-1000', 500), If(Sum(Qty) > 250, Dual('251-500', 250), If(Sum(Qty) > 100, Dual('101-250', 100), If(Sum(Qty) > 50, Dual('51-100', 50), If(Sum(Qty) > 25, Dual('26-50', 25), If(Sum(Qty) >= 10, Dual('10-25', 10), Dual('<10', 0)))))))) , Customer))
Sort by numeric, descending. This could be quite slow if the data set is large. Both aggr() and calculated dimensions can be slow to calculate.
Yes, here is some sample data. You will notice customers may bave various product models. I am summing the models to get the total and it is this total that I want o apply the filter/slider.