see the attached example
you need to create a dimension for bins - include or exclude will not do that but fixed will
I used the formula below to create my own bins
and returned this
you could also use the "Bin" function on the fixed total - just convert to a dimension (right click and convert to dimension) then create the bin
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
bins example.twbx 2.4 MB
Thank you so much for the solution.
Quick question - Let's say in your dataset, how can I draw a box-plot based on the value of sales. If I select box-plot, it will calculate based on the number of customers.
Please mark my initial response correct to close the thread and post your second question as a separate post
That makes sense. Please see the new post:
The specified item was not found.