Interactive Chart: Combine String and Date in a chart

[Poncho36]

I am having difficulties to graph which I want to have the prior Mothns overall reulsts and the weeks of the year showing the tendency.  I could graph when only are dates such as 3/3/24 and so on, but when I want to combine into the graph with the month of March 2024 ( not a specific date just overall) its not showing nothing. Its there a way I can grap this data. I was thinking of making all the date as strings, but I think I couldnt.  

[terry10]

@Poncho36 

If this hasn't been answered, try posting it in the Designer Discussion instead of the Industry Discussion (and tag Reporting).

[LicasMaxj]

Yes, you can graph it, but the monthly value must still have a valid date. Instead of using only “March 2024”, assign a representative date such as 01/03/2024 or 31/03/2024 for the monthly total. Charts usually require real date values to plot on the axis. Then keep the weekly dates normally (e.g., 03/03/2024, 10/03/2024). Avoid converting dates to strings, because most chart tools cannot treat them as time data.