7 Replies Latest reply on Jan 4, 2017 2:20 AM by Nikunj Bhardava

# How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hey Tableau Community,

I'm brand new to Tableau and after watching the some of the into videos, I'm still not sure how I would be able to combine multiple binomial (text or null) dimensions into one viz showing the frequency of each dimension. Ideally it would be a highlight table where the sign first noticed would be in the column and then the number of times it was noticed would be in the rows. The reason the different signs are binomial dimensions is because two or three could be noticed at one time and the data collection form consists of boxes where staff check if something is true. Therefore the data is not categorical and I can not seem to get a grasp on how to be analyze this type of data. Does has one have any detailed instructions on how to do this?

Attached is the workbook I'm using including the date/time the particular case happened, the case number, location of the case and then the signs noticed.

Thanks in advance for the help!! Also, if there is a video series covering this type of question could someone please point me in the right direction?

Joyfully,

Hannah

• ###### 1. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hi Hannah,

Can you please elaborate more? probably with some example what do you want from this data?

Thanks, Nikunj

• ###### 2. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hi Nikunj,

Ideally I would like to have a bar chat with all the different signs horizontally and total number of cases containing those signs vertically. I could create a visual using excel after some cleaning but I want to avoid that. The reason I can't do so right now is because the signs (about 15 of them) are all different dimensions vs 1 dimensions with different categories and I can't figure out how to combine them into one chart/viz.

• ###### 3. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hello Hannah,

This is essentially a form of survey data. Steve Wexler has done a fantastic series of posts and Tableau conference sessions and a whitepaper on working with survey data in Tableau, check out Visualizing Survey Data – Data Revelations . In particular for the analysis you want you're likely going to want to pivot the data so instead of having columns for each observation type there's a column for the observation type and a column for the observation.

Jonathan

2 of 2 people found this helpful
• ###### 4. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hi Hannah,

Apology, if i don't get your requirement. I tried something related to what you are asking. can you please take a look and let me know if is it something that you are looking for?

Thanks,Nikunj

1 of 1 people found this helpful
• ###### 5. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hi Nikunj!

This is exactly what I'm looking for! How did you do this?\

Thank you so much for taking the time to help me with this!

• ###### 6. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Thank you Jonathan!

• ###### 7. Re: How to combine multiple binomial (text or null) dimensions into one viz showing frequency of instances the particular signs were noticed

Hi Hannah,

To make your different sign counts. you need to re-structure your data by using PIVOT within the tableau.

See and follow attached DOC - How you can make PIVOT within the tableau. after PIVOT you can follow the workbook for calculation and building the chart.

Hope this helps.

Let me know if you still face any issue.

Thanks,

Nikunj