Hi team ---
I am comparatively new to Alteryx tool. I am currently on one of the use case where I need to build a filter with specific condition so i can validate the financial data easily using Alteryx tool. Below is a sample dataset.
Condition: - I need to know which dates return is greater than +/-5% on each account-segment level.
Can someone please help me regarding this.
ACCT_NUM | SEGMENT | START_DATE | END_DATE | ROR |
1234 | Gross | 12/31/2021 | 1/1/2022 | 0 |
1235 | Gross | 1/1/2022 | 1/2/2022 | 0 |
1236 | Gross | 1/2/2022 | 1/3/2022 | -0.3907 |
1237 | Gross | 1/3/2022 | 1/4/2022 | -0.9805 |
1238 | Gross | 1/4/2022 | 1/5/2022 | -0.7017 |
1239 | Gross | 1/5/2022 | 1/6/2022 | 0.01986 |
1240 | Gross | 1/6/2022 | 1/7/2022 | -0.1403 |
1241 | Gross | 1/7/2022 | 1/8/2022 | 0 |
1234 | Net | 12/31/2021 | 1/1/2022 | 6 |
1235 | Net | 1/1/2022 | 1/2/2022 | 0 |
1236 | Net | 1/2/2022 | 1/3/2022 | -0.0917 |
1237 | Net | 1/3/2022 | 1/4/2022 | -0.1895 |
1238 | Net | 1/4/2022 | 1/5/2022 | -6.7877 |
1239 | Net | 1/5/2022 | 1/6/2022 | 0.05245 |
1240 | Net | 1/6/2022 | 1/7/2022 | -0.2653 |
1241 | Net | 1/7/2022 | 1/8/2022 | 0 |
