A preparation step converts a column to dates, but ambiguous values like 03/04/2026 are interpreted incorrectly. What is the best response?

Published
  1. Accept the interpretation because every date is syntactically valid
  2. Sort the strings alphabetically and keep them as measures
  3. Change the chart title to the intended date format
  4. Use the source's documented date convention and validate representative values

Comments — 0