I am trying to import an Excel file with a date field.
The date field appears as numeric, so I switched it to Date & Time using PARSE_DATE(“%d-%m-%y”, Date).
However, when I drag the Date to the Dimension, the chart displays a system error. What did I do wrong? Thanks!!
That’s strange! Usually Looker Studio will even let you drag in a non-date dimension into the date dimension, but just won’t do anything with it. Is there anything you can click on that tells you more about the error?