Sorting question

John-Peddle
John-Peddle Contributor
in Charting

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 Coach
    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'

Answers

  • Godiepi
    Godiepi Coach
    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'
  • John-Peddle
    John-Peddle Contributor

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

This discussion has been closed.

Categories