Forum Discussion
Bucketing in Histogram
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.
@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🙂
4 Replies
@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🙂
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)
