Sorting question

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!


Screen Shot 2019-03-28 at 10.21.12 AM.pngScreen Shot 2019-03-28 at 10.23.26 AM.png

Best Answer

  • Godiepi
    Godiepi 🟣
    Answer ✓

    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)

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'


This discussion has been closed.