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!
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
