I would like to use a number of values for a dimension. For example, I want to classify customers based on the number of orders. Customers who order once a week, order twice a week and order three times a week. Then I want to make a dimension of this to see how many customers fall into each category. I use Count (distinct (invoice)) / number_of_weeks to measure the ordering frequency. From this, therefore, 0-1, 1-2, 2-3 & 3+ must come as different dimensions in one field. Anyone have any idea? Thanks in advance!
