This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to group my customers based on size and segment. For example if a customer is in segment X, and has the size of 18, then it should be in customer group 15-20.
I have around 400 combinations of such groupings and it is really difficult to do it using the formula option.
I was thinking of using an input file to get the customer grouping. Basically it would say if the customer segment is X, and it lies between the min and max of the group banding then return me the grouping of that row.
I want to get the solution such that even if there is no customer, I get the grouping displayed. I am taking a left join of it to get over it, however, if I display the results on tableau, I am not getting the desired output if I filter for year in tableau.