Chart X-Axis Label Lags A Day

💬 App Building
, ,
1

Hi, everyone! I have searched around the forums and found similar topics, but no solution worked for me. It's also maybe because the Chart component I'm using isn't that complicated, at first. But maybe because I'm a rookie on this, I can't solve this issue.

  1. My goal:
  • I want to show the proper timezone or date in the Chart. It lags a day behind.
  1. Issue: The X-axis label in chart lags a day behind from the actual data source.

I have a GSheet as a source of data. The data then queried using SQL to get basically summary of several things including Weekly Results. The result is all is well and shows the correct date formats. It's also ISO-formatted in my JS queries, changing from the value MM/DD/YYYY to the proper format of YYYY-MM-DD.

However, when building charts, the X-axis label shows 1 day behind from the actual data. I directly uses the Chart's data picker/dropdown instead of setting it dynamically using the {{ }}. Just for your reference maybe, if I click the dynamic value, it shows {{ formatDataAsObject(overall_assess.data).agent_week }}. It returns array of 12, with correct dates such as 2025-05-19. But my chart still shows May 18 instead.

*ignore the incorrect percents

image
image982×370 31.6 KB

  1. Steps I've taken to troubleshoot:
    I tried using JS queries to transform the data also try to set it to ISO format, change timezone. But the Chart still shows different date from the actual data it refers to.
  2. Additional info:
    As you can see, the data source is different from the chart shows above. I can't find a way to even change timezone for the Charts.
    image
    image400×404 20.7 KB

Thanks in advance!

2

EDIT: I was playing around the chart. If I uses other type of bar charts, like Group, and then drag it wider, like simply drag it so wide, it shows proper label and date. However, if I return to stack, it shows unnecessary labels and somehow the bar graph stuck in between of May 17 - May 20. Is this an error in label or on how I set it up? Anyway, to actually makes more precise labels?

If hovering over the data, it actually shows correct value and data.