Forum Discussion

baneworth's avatar
baneworth
Helper III
3 years ago
Solved

wrong Month values showing

Hello Community,   i created a simple chart with Values for the Y axis and Month for the x axis. The Month comes from our company calender and stretches from Jan2022 - Dec 2023   What i can not ...
  • AllisonKennedy's avatar
    3 years ago

    baneworth  The Month column is numeric, and your axis is set to 'continuous'

     

     

    So it's showing all numbers in between (months only have 12, but that doesn't fit within base 10 numbering system).

     

    Either change your axis to categorical, or use "End of Month" column from your date table (if you have one) as that will be a 'Date' datatype instead of 'number' and will behave with base 12 month system you want 🙂