7 Replies Latest reply on Feb 15, 2016 1:36 PM by Yuriy Fal

# How do I create a Distribution Differences by Segment chart?

The following is the process used in Excel starting from a contingency table - the needed outcome is the Distribution Differences by Segment chart below.

rg

 Table Segment Profile 1 2 3 RowTot a 20 120 120 260 b 40 90 240 370 c 60 60 240 360 d 80 30 120 230 ColTot 200 300 720 1220 Segment Profile 1 2 3 Total a 10% 40% 17% 21% b 20% 30% 33% 30% c 30% 20% 33% 30% d 40% 10% 17% 19% 100% 100% 100% 100% Segment Profile 1 2 3 a -11% 19% -5% b -10% 0% 3% c 0% -10% 4% d 21% -9% -2%

• ###### 1. Re: How do I create a Distribution Differences by Segment chart?

Hi Richard,

Something like this?

and a contingency table ds.

Yours,

Yuri

• ###### 2. Re: How do I create a Distribution Differences by Segment chart?

Yuri,

First of all, thanks for taking the time to think this through and provide a solution, which mimics the spreadsheet approach used in excel.  It is very elegant and easy to follow.

So let me complicate this further.  Many data sources have respondent level information with segment and classifications across a variety of classifications including demographic profiles, clusters, and factor groupings.  The solution approach provided suggests that a pre-processing step is needed to develop individual a contingency tables and then use that data as input to obtain the desired views of the data.  Scaling this approach, any filtering at the respondent level would need require pre-processing to be repeated in the workflow.

So is there a method to create the final output directly from the original data source without a pre-processing step?

I.e., 20 records with Segment 1 Classification "a", 40 records with Segment 1 Classification "b", etc.

rg

• ###### 3. Re: How do I create a Distribution Differences by Segment chart?

Hi Richard,

Please find the attached wb w/mods

together with a Raw Data table.

Yours,

Yuri

1 of 1 people found this helpful
• ###### 4. Re: How do I create a Distribution Differences by Segment chart?

Richard, Can you provide a sample file.

I think it should be pretty easy with use of LODs

• ###### 5. Re: How do I create a Distribution Differences by Segment chart?

Yuri,

Thank you for your quick response!

To be sure, your help has moved me far along in a project that is translating a working data model into the Tableau environment.

Best regards,

rg

• ###### 6. Re: How do I create a Distribution Differences by Segment chart?

Aseem,

Here is the raw data file producing the contingency table and output objectives.

rg

• ###### 7. Re: How do I create a Distribution Differences by Segment chart?

Richard, you're welcome.