Date values disappear when turning a question into a model

Database: MySQL

Metabase Version: 0.43.0

Issue: Date value disappear when turning a question into a model.

Steps taken prior to issue.

  1. Asked a question which counts the distinct number of order, grouped by date (to the hour).

Example would look like this:

  1. Turn the question into a model.

When I do this, the date column's values disappear. I have tried editing the meta data but it does not work.

As you can see, the Date column's value are gone.

I am not sure how to solve this or why the problem is occurring.

Hi @pjhaberman
It is caused by your "Add Time" column is using casting in the Data Model.
I've created an issue for it:
https://github.com/metabase/metabase/issues/22519 - upvote by clicking :+1: on the first post

1 Like

Ok, makes sense after reading the github thread. It is double casting.

Thanks!