Charting

Charting

Bar chart years not in sequence

I am not sure how to fix my years to be in sequence. Like 2021 the 2022 then 2023. Currently I am using a bar chart and data for 2023 is before 2021. Any help is appreciated

image.png

Best Answers

  • edited October 2023 Answer ✓

    Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.

    IMG_7613.jpeg


    If I solved your problem, please select "yes" above

  • Contributor
    Answer ✓

    @Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Answers

  • edited October 2023 Answer ✓

    Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.

    IMG_7613.jpeg


    If I solved your problem, please select "yes" above

  • Contributor
    Answer ✓

    @Gunjan after you apply what Cole recommended, you could also plug your series/category field into the sorting as well. This will have all your categories in the same rank in each year.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In