0 votes
1 view
in BI by (15.1k 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 (41.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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 25 in BI by Vaibhav Ameta (15.1k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...