I’ve been working in GoodData setting up multiple insights and a KPI dashboard. I have a question about handling dates that I’ve not found an answer to.
My data has an order completion date (ship date) that is either in the form MM/DD/YYYY or MMM YYYY (eg. FEB 2021) or YYYY/MM/DD. I have tried all three formats when importing the data. When I import the data, I have the attribute marked as text. I wish to produce a line chart based on month and year of the shipments showing the total value of the orders shipped. When I setup the insight, I get the dates in alphabetic sequence (Apr 18, Apr 19, Apr 20, Aug 18, Aug, 19, Aug 20 etc.). What do I need to do to get GoodData to see these values as dates and report by month?