Bucket Ordering

damen

Hi,

I am working with pricing buckets of home loans. I have created two case statements. One that puts each loan id into a piricing bucket based on the loan amount. the second is to order those buckets in what would be numerical order.

I am getting a graph that, when the bucket order is being applied, doesnt want to bucket some of the loans in the proper buckets.

Here is what I am seeing.

Without sorting:

With sorting:

I need to sort them - to make it more like a histogram but I cannot have them out of order. When we apply the ordering, for some reason the buckets want to be broken out.

Any ideas?

jessdoe

Your sorting is showing up as a string. Try changing your beast mode to = 1 if it's currently = '1'. If that doesn't work you may need to apply some aggregation in your beastmode bucketing or on the sort column to get the data to roll up in the correct bucket.