Bucketing in Histogram

[Anonymous]

Hi Friends,

I want to make bucketing of Histogram like -

10-20, 20-30 , 30-40 , 40-50 ..............

but as you can see in below image, it is creating default like 13-23, 23-32 which is not making sense and also not looking good.

Could anyone help me to make in numbering in range of 10 or range of 5 ?

Thanking you all in advance.

[Fowmy · Accepted solution]

@bhuprakashs


Please check the attached file, which I used for a similar solution:

You can download the file: HERE

________________________

If my answer was helpful, please consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer🙂

Youtube Linkedin

[FrankAT]

Hi @Fowmy 

I agree with your solution with the disconnected table, but I think we have a slightly difference to take into account > if the volumn is exactly on the boundary between to groups, as an example Volumne = 20 (see figure)

In result this volumn will be counted twice (see figure):

Solution: Changing the operator as shown in Measure 2.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Fowmy]

@FrankAT
Oh, it's my mistake.

I corrected it

Thanks !

[Anonymous]

Thanks a lot for prompt help @Fowmy  @FrankAT