Sorting question

John-Peddle

Jus wondering if anyone else has seen this and what the cause might be, or how to correct it. We have a standard Grouped Bar + Line chart and are sorting by the metric used on the X-Axis, but for some reason those that have no delay, i.e. not between 0-XXX, appear at the top instead of at the very bottom, below those with a 0 day delay. Also tried to sort under General > Sort Each Category but that didn't correct it either. Thoughts? Thank you!

 

Godiepi

your x-axis field has some null values, 

if it is a beastmode then just do ifnull(("YourBeastmode"),0)

if is not a beastmode then create one with ifnull(`yourfield`,0)

John-Peddle

Yes sir, @Godiepi, that did the trick! Thanks for the qick response and assistance. Have a great day!