Hi -- I am relatively new to Alteryx and trying to figure out how to replicate a CountIf in Alteryx...
My current table is as approx as follows:
Note (if helpful) though I don't think should change the formula)
W - Date
X - V_W String
Y - V_W String
Z - Integer
*** (target outcome) - is a count of the Zs total present for XY combinations but I don't want to drop the W value becaus
| W | X | Y | Z |
| 1 | A | C | 50 |
| 1 | A | D | 50 |
| 2 | A | C | 50 |
| 2 | A | D | 50 |
| 3 | A | C | 50 |
| 3 | A | D | 50 |
| 4 | A | C | 50 |
| 4 | A | D | 50 |
I am trying to get the following output:
| W | X | Y | Z | *** |
| 1 | A | C | 50 | 4 |
| 1 | A | D | 50 | 4 |
| 2 | A | C | 50 | 4 |
| 2 | A | D | 50 | 4 |
| 3 | A | C | 50 | 4 |
| 3 | A | D | 50 | 4 |
| 4 | A | C | 50 | 4 |
| 4 | A | D | 50 | 4 |
Any advice? My summarize function as currently structured is not producing this..
