grouping bins in a tableau histogram

Question

I have recently started using Tableau. I got a histogram like this:

I want to group the bins after 34000K and make it like "34000k +" as in excel. Please help.

Armin · Accepted Answer · 2018-03-05T13:01:19.447

2

There are many ways to do this, a simple one may be creating a group based on values of your field "Number of Shares Of..".

Edit: First create a calculated field to generate the bins manually. The formula looks like this:

INT([Your variable]/[bin])*[bin]

Then, on this calculated field create a group. Select the members that you want to group (34000K+), and then click Group. Name it as you want.

Finally, use this created group in the column shelf.

edited Mar 05 '18 at 13:01

answered Mar 02 '18 at 19:04

Armin

I did that and created a group "34000k+". Now this group is a dimension and I am getting bar chart instead of histogram. I am trying to figure out how to create a histogram. – bipvan Mar 03 '18 at 01:36
how can I get [bin]? – bipvan Mar 05 '18 at 16:37
I did INT([Number of Shares Offered]/[Number of Shares Offered (bin)])*[Number of Shares Offered (bin)] – bipvan Mar 05 '18 at 16:39
I mean the size of each interval, just a number, in this case may be 2000. – Armin Mar 05 '18 at 17:41

1 Answers1