Hello Alteryx Team, I'm a beginner in Alteryx designer and I have a question with Count distinct tool in the designer: the case is I need to create a star schema model attached below the count of service is straightforward but the count of customers must be distinct count and here is the issue. Count distinct is correct on the lowest granularity level ( including all the dimension list above the distinct ) but when I 'm trying to visualize the count distinct against any higher part of granularity the count distinct is not correct because the count distinct result aggregated. Let's look at the following example : This is the original data Pkey_customerBank_NameAge_GroupGovernorateAccount_Number1110111Ahli40-60Alex1010106660666Ahli40-60Alex8080802220222QNB25-40Giza2020202220222Ahli25-40Giza3030303330333NBE25-40Cairo4040403330333NBE25-40Cairo5050503330333Ahli25-40Cairo6060603330333Ahli25-40Cairo707070 this is the output of Alteryx workflow and input to Tableau Count distinct CustomerBank_NameAge_GroupGovernorate1Ahli25-40Cairo1NBE25-40Cairo1Ahli25-40Giza2Ahli40-60Alex1QNB25-40Giza When trying to visualize over Tableau the count distinct number of customers against the governorate only or Age Group dimension only I aggregate and give a wrong number Like: Got AnswerExpected AnswerCairo2125-4042 Is there any idea or solution to handle this issue.

Count distinct not additive field

Hello Alteryx Team,

I'm a beginner in Alteryx designer and I have a question with Count distinct tool in the designer:

the case is I need to create a star schema model attached below Star Schema Model.jpg

the count of service is straightforward but the count of customers must be distinct count and here is the issue.

Count distinct is correct on the lowest granularity level ( including all the dimension list above the distinct ) but when I 'm trying to visualize the count distinct against any higher part of granularity the count distinct is not correct because the count distinct result aggregated.

Let's look at the following example :

This is the original data

Pkey_customer	Bank_Name	Age_Group	Governorate	Account_Number
1110111	Ahli	40-60	Alex	101010
6660666	Ahli	40-60	Alex	808080
2220222	QNB	25-40	Giza	202020
2220222	Ahli	25-40	Giza	303030
3330333	NBE	25-40	Cairo	404040
3330333	NBE	25-40	Cairo	505050
3330333	Ahli	25-40	Cairo	606060
3330333	Ahli	25-40	Cairo	707070

this is the output of Alteryx workflow and input to Tableau

Count distinct Customer	Bank_Name	Age_Group	Governorate
1	Ahli	25-40	Cairo
1	NBE	25-40	Cairo
1	Ahli	25-40	Giza
2	Ahli	40-60	Alex
1	QNB	25-40	Giza

When trying to visualize over Tableau the count distinct number of customers against the governorate only or Age Group dimension only I aggregate and give a wrong number Like:

	Got Answer	Expected Answer
Cairo	2	1
25-40	4	2

Is there any idea or solution to handle this issue.

Transformation

Tableau

Accepted answers

SamDesk

Hello @Ahmed_Massoud90,

In addition to @yalmar_m's response above, if your need for the count distinct is only within Tableau, then you can simply hold right-click and drag any dimension in Tableau onto the sheet and select an option of count distinct for that selected dimension. This should hopefully solve your problem.

I think the misunderstanding may be that the count distinct function from Alteryx does not create a dynamic distinct count field, unlike in Tableau where distinct counts update relative to the filters and dimensions present in the sheet. Alteryx is creating a fixed distinct count at the granularity specified and is then open to aggregation by Tableau.