Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Text columns are converted aggressively to DateTime in charts #11069

Open
flamber opened this issue Oct 7, 2019 · 1 comment

Comments

@flamber
Copy link
Contributor

@flamber flamber commented Oct 7, 2019

Describe the bug
Text columns are converted aggressively to DateTime in charts and x-axis shows date even when scale is set to Ordinal.

To Reproduce
Set viz to Bar or Line for the following query:

SELECT '1396-01' AS t, 40 AS c UNION ALL
SELECT '1396-02' AS t, 40 AS c UNION ALL
SELECT '1396-03' AS t, 40 AS c UNION ALL
SELECT '1396-04' AS t, 40 AS c UNION ALL
SELECT '1396-05' AS t, 40 AS c UNION ALL
SELECT '1396-06' AS t, 40 AS c UNION ALL
SELECT '1396-07' AS t, 40 AS c UNION ALL
SELECT '1396-08' AS t, 40 AS c UNION ALL
SELECT '1396-09' AS t, 40 AS c UNION ALL
SELECT '1396-10' AS t, 40 AS c UNION ALL
SELECT '1396-11' AS t, 40 AS c UNION ALL
SELECT '1396-12' AS t, 40 AS c

Screenshots
Screenshot_00000

Metabase 0.33.3 and master (commit 7b2431e) with various browsers.

Additional context
https://discourse.metabase.com/t/text-is-considered-as-date-time-in-visualization-v0-33-3/7581

@michaeldam

This comment has been minimized.

Copy link

@michaeldam michaeldam commented Nov 7, 2019

Full month results with ordinal formatted YYYY-MM, are being attributed to the first of the month as opposed to the last. When selecting ordinal, the content should not be interpreted and modified.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
5 participants
You can’t perform that action at this time.