Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, is it possible to limit the amount of groups the class function generates? I have a large amount of data of customers and products and the percent of returns,this is the value to class and goes to -10,000% to 10,000% but the user only want few groups with the count of clients and products that fall in each range ( < 0%,0-10%,10%-20%,20-30%....>100%) , so when using the class function generates lots of groups (-10,000 % <= x <= -9,900%).
I tried to use set analysis instead but it's pretty difficult to control but sides of the information (clients attributes and product attributes), and time and the way the user wants to navigate (select client's attributes and then see how the client's products fall in each range to detect which have more returns, select more than one month to evaluate), so i believe the best option would be the class function but how to make it work with this?
Any help would be appreciate!
Use an if statement to restrict the values you want to class.
If( Value < 0, '<0%', if(Value > 1, '>100%', Class(Value,0.1)))