I have yet to successfully use dates as an axis in ChartGenerator. Ideally, I would like to be able to use more natural date formats e.g. %B %Y or %m %Y and set the scale accordingly based upon time increments. Is this possible (in Chart Generator or another transformer) ? Or am I going to need to take it out into PowerBI, Excel, etc?
Question
Dates in charts
+52- Celebrity
+4- Contributor
Hi @paul_c_2,
I've had this issue before too - the workaround for me has worked in the past is this:
- Create additional features to 'fill the gaps' of any missing months (i.e. if you have months 202301, 202303 and 202304, create 202302) to give your chart a fighting chance of having consistent distances between months) - in this case not needed.
- Sort by Month, to order your features correctly. They need to stay in the correct order for the ChartGenerator
- Use Attribute Manager/Creator to add '01' to the Month (so that the DateTimeConverter will work)
- DateTimeConverter to convert this date into '%B %Y'
- Plot values in ChartGenerator
All the best,
Martyn
+1- Contributor
Hi @paul_c_2,
I've had this issue before too - the workaround for me has worked in the past is this:
- Create additional features to 'fill the gaps' of any missing months (i.e. if you have months 202301, 202303 and 202304, create 202302) to give your chart a fighting chance of having consistent distances between months) - in this case not needed.
- Sort by Month, to order your features correctly. They need to stay in the correct order for the ChartGenerator
- Use Attribute Manager/Creator to add '01' to the Month (so that the DateTimeConverter will work)
- DateTimeConverter to convert this date into '%B %Y'
- Plot values in ChartGenerator
All the best,
Martyn
awesome, will give it a go! Merci