Interactive Chart X-Axis range not changing with data

Question

I have an Interactive chart that gets sent out in an email as a static image, but I can't get the X-Axis to match the date range.

For example: The date range for the data entering the tool is 2/26/2023 - 4/16/2023, but as you can see the X axis range is from 07/10/2022 - 4/16/2023. The "lines" are plotted correctly based on the data, but the X Axis range goes back much further than the data.

Right now the range is set to Auto. I know you can set a custom range, but I need to do this dynamically as this chart is only supposed to show the "previous 8 weeks from today"; which is why the data-set going into it is that way.

Why would the chart go back almost an entire year when the data going into the tool is only from the last 8 weeks?

How can I dynamically set the X Axis range?

Thanks,

Craig

csh8428 · Answer

@gautiergodard

Here's a packaged workbook with the data. It's the exact same data structure(columns and rows) and tools from the workflow., except the data itself has been anonymized.

Sample.yxzp

gautiergodard · Answer

Are you able to share some sample data? I would like to replicate the scenario on my end.

csh8428 · Answer

@gautiergodard

Yes, the data type = Date and it' sonly the date range I want. There are only 8 records going into it with a date range of Feb 2023 to April 2023.