Creating 2 Pivot Tables(different filters) and comparing them to get an total count

Hi All,

I am trying to build the following in altreyx and not sure if it can be done.

I have attached an excel with raw data set and the 2 pivot tables i need and the final outcome.

the goal is from one data set to create 2 pivot tables which are calculated using different set of filters and count distinct on IDs.

in the final comparison , i want to look at both the tables created and count the unique IDs to get overall count. can this be done in this tool?

Thanks

Altreyx Test.xlsx

Developer Tools

Transformation

Accepted answers

Kenda

@SR My apologies, I did not see the >1 stipulation the first time. See if the attached workflow is what you're looking for.

multiple filters.yxzp

All comments

Kenda

Hey @SR! I may be reading your question wrong, but because the criteria of 'Diverse=yes and Hired=Yes' (Table 1) is a subset of just 'Diverse=Yes' (Table 2), could you just add a Filter tool after your input that says

[Diverse] = "Yes"

then use a Summarize tool to group by ID? Then, you could add a Count Records tool if you wanted to get the count of all the unique ID's.

compare different filters.PNG

Hi. Thanks for the quick reply, you are correct in that diverse = Yes applies as a filter for both tables. However Hired = 'Yes' only apply to table 1. while table 2 has a different filter based on count(candidate id) >1. maybe i need to create 2 flows and join them for the compare of unqiue counts (table 1+ 2).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703