Create Bell Curve in Tableau

6.4k Views Asked by At

I am trying to create Bell Curve from data, i.e.

x = number of shoes y = number of records

From the data, most records, i.e. women have one pair of shoes, so 1 would be the center of the x axis.

How to approach this? Here is what I have so far

enter image description here

Data Structure

enter image description here

2

There are 2 best solutions below

0
Alex Blakemore On BEST ANSWER

Put "Pair of Shoes" on the columns shelf. Change it do a dimension. I would leave the data type as a number and make it continuous.

Then put SUM(Number of Records) on the rows shelf, and make sure it is continuous.

You'll see a distribution, but it won't look like a bell curve

1
meimei On

There's a couple of ways to do this. One of the fastest ways is probably to turn "pairs of shoes" into a text dimension. There are a couple of ways to do that, this link should help.

Use the bar graph. Pairs of shoes becomes the dimensional entry. You can then use the count distinct feature: