Hi community,
I am trying to classify a large amount of information into the following banding.
RevenueBanding |
A = <100 |
B = 100 - 1,000 |
C = 1,001 - 2,500 |
D = 2,501 - 5,000 |
E = 5,001 - 7,500 |
F = 7,501 - 10,000 |
G = 10,001 - 20,000 |
H = 20,001 - 50,000 |
I = 50,001 - 100,000 |
J = 100,001 - '250,000 |
K = 250,001 - 500,000 |
L = 500,001 - 1,000,000 |
M = 1,000,001 - 2,000,00 |
O = >4,000,001 |
I thought I could use the "switch" formula but I am getting an error everytime.
Does anybody have faced this before? Any ideas on what Alteryx tool I can use to do this?
Thank you.
Solved! Go to Solution.
You can use a case statement in the formula tool, or a tool specifically designed to do this is called the 'Tile Tool'- one of its options is to pick specific cutoffs, so thats the one to choose for your case.
Thank you all for your inputs. I am using the "title" tool and an additional "Find/Replace" to match my labels with the title num in the output.
I really appreciate your help on this.
Gracias!
User | Count |
---|---|
35 | |
27 | |
8 | |
7 | |
7 |