Result are different in tableau and alteryx. Please suggest

Onemajor

As I run the workflow in alteryx, its summing population and showing the same population across each market.

But as I am using the same data in Tableau then its summing up again and showing different number.

Is there way to solve this issue so that the number looks accurate in Tableau?

Thank you!!

Population.yxmd

Pop in Alteryx.png

Pop in Tableau.png

Workflow

Datasets

Output

Best Practices

Tableau

Data Investigation

Accepted answers

All comments

Qiu

@Onemajor
It looks to me that Tableau is also giving the same population acrross the market, which is the consistent with your input data.

The results from Alteryx and Tableau are just same to me. 😁

Population-r1.yxmd

Yoshiro_Fujimori

Hi @Onemajor ,

This should be a topic on Tableau Community, but you may try to set Tableau as below.

Onemajor

I mean, if date is added in the column then the population is same across each date. If I don't add date then its summing the population. But regardless of the date population would be the same, which I am trying to get. So, is there way to get the same population without adding date in the column?

Screenshot 2024-06-20 092711.png

apathetichell

@Onemajor If you don't want to include Date - don't include it in your summarize field. I don't get this. Are we talking cosmetic issues or data issues? As pointed out by @Yoshiro_Fujimori and @Qiu you do not seem to have a data issue.

Onemajor

Sorry, I think I am not able to explain correctly. let me try again.

For example, in this dataset lets select SLC market. If you look at the Date column and Sum_Population column then you see on 06/12/2024, 06/13,2024 and 06/14/2024 its the same which is 1460341. Now I want to take this data from Alteryx and add in Tableau. Upon doing so, if I add "Date" in the Columns and "Market" in the row then the result is exactly the same. but this is not what I wanted.

What I want is: If I add "Market" in the row and (don't add "Date" in the column) then it should still generate the same population for SLC which is 1,460,341 but its summing up for each date and then generating value as 4,381,023. Population should not change regardless of date added or not. This is what I am trying to achieve. Here is the table that I am trying to get in Tableau(without adding date)

Market	Population
DFW	2978407
LV	1244443
SLC	1460341

Hope this helps to understand the problem. Thank you

Qiu

@Onemajor
You mean like this?

Population-r2.yxmd

apathetichell

I think what you are trying to do is do a summarize/group by Market/group by population - sum sales.

your resulting dataset will be your sales sum by market - with your population number carried over.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703