Hello! I have a workflow where I have 2 different Tile Tools. For the 1st tile, I have the Age Group (Tile #1 is N/A, Tile #2 is Under 35, Tile #3 is 35-44, Tile #4 is 45-64, Tile #5 is 65-74, Tile #6 is 75+ and Tile #7 is N/A. For anybody with an age under 20 or over 100 should be grouped into N/A, so I'm not fully sure if I did that correctly.
For the 2nd Tile, I have the AUM Group (Tile_Num 1 is Under $10k, Tile_Num 2 is $10k-$10M, Tile_Num 3 is $10M-$50M, Tile_Num 4 is $50M-$100M and Tile_Num 5 is over $100M).
The AUM tile should align with the AUM group column, but when looking at the output, that doesn't seem to be the case and I'm not 100% sure how to get the AUM tile to align with the AUM group column. Attached I have the workflow, screenshots of both Text Input tools and Tile tools, along with a snippet of the output. Can someone please take a look and provide suggestions on how I can correct this? I would greatly appreciate it!
Why don't you give a try to formula tool that will be easy way to deal with this.
you can share the sample data so we can help with the formula as well if needed.
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |