Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

This is how my histogram looks like

histogram

I want to group the bins after 34000K and make it like "34000k +" as in excel. Can anyone help me on this?

1 Answer

0 votes
by (47.2k points)

One of the simple way is by creating a group based on values of your field "Number of Shares Of..".

First of all create a calculated field to generate the bins manually. This is how your formula should look like:

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 the Group and name it whatever you want.

Finally, you can use this created group in the column shelf.

Firstly register yourself in an industry-recognized Tableau Certifications such as you can register for our Tableau Training Course.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Apr 4, 2020 in BI by Anup (1.6k points)
0 votes
1 answer
asked Jul 20, 2019 in BI by Vaibhav Ameta (17.6k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...