Hello everyone,
Ran into an issue with alteryx. Still building up skills, hoping someone can help with the below.
I want to add a column to the below dataset that effectively identifies a threshold using some logic.
| Acct | DELTA $ |
| A | 11,940,549 |
| B | 621,458 |
| C | -6,847 |
| B | -19,602 |
| A | -2,601,305 |
| B | -1,570,860 |
| C | 8,363,393 |
| B | -16,322,719 |
The below is how I would like the threshold to be added. The simple logic being if Abs(Delta) > 50,000 grouped by Acct.
But i want the count to increase on a specific account if there are more than one. Instead of just identifying, i would like to have a increasing number or alphabet, whatever makes it easier.
| THRESHOLD | Acct | DELTA $ |
| 1 | A | 11,940,549 |
| 1 | B | 621,458 |
| | C | -6,847 |
| | B | -19,602 |
| 2 | A | -2,601,305 |
| 2 | B | -1,570,860 |
| 1 | C | 8,363,393 |
| 3 | B | -16,322,719 |
Any help is highly appreciated. have a good day!!
thanks!
