Hi,
I am trying to get an output from comparing 2 sets of data.
There 2 sets of data are decimals, I would like to flag anytime the data has moved from below 0.2 to above 0.2 and anytime the data has moved to the next threshold/range of 0.1 below or above (0.2 - 0.3, 0.3 - 0.4, 0.4 - 0.5 etc.).
I have some sample data and a desired output below.
Yesterday | Today | Output |
0 | 0.29 | Change up to threshold 0.2 |
0.18 | 0.19 | No Change |
0.21 | 0.34 | Change up to threshold 0.3 |
0.84 | 0.79 | Change down to threshold 0.7 |
0.54 | 0.52 | No change |
0.28 | 0.31 | Change up to threshold 0.3 |
24.23 | 24.11 | Change down to threshold 24.1 |
2.43 | 0.22 | Change down to threshold 0.2 |
Thanks in advance,
Ash
Solved! Go to Solution.
Hi @aka_ash
I attached the WF below. You can see by the Output Alteryx column, it matches with how it was supposed to be. Let me know if you have trouble understanding the functions used.
Pedro.
@aka_ash
I assume by 'No Change' means the data from column 'Today'.
@aka_ash
Glad to help and thank you for the accept mark.😁