Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
4 years ago
Solved

tick label missing in charticulator

I'm trying to create a column chart in charticulator. My data starts from Jan. 3rd and ends on June 30th. In X axis, I populated date, for some reason, Jan. is not appearing in x axis label. I would ...
  • Jeanxyz's avatar
    Jeanxyz
    4 years ago

    Burningsuit Thank you for the detailed explanation. Indeed the date seems to cause errors when it's populated to x axis or text label, the date is always 1 day less than the correct value.

     

     

    I find two solutions: 1) if users want to show date as a text label, they should use DateAsInteger instead of Date in the text field. In the chart below, I have created two text label, the label on the buttom use Date, which is not correct, the label on top use DateAsInteger which is correct. 

    2) in the text field, user can still use Date, but they should manually add 86400000 to the date value, in this way, the text label will automatically add 1 day to the default date.