we are using mysql and not able to use datefilter, used below workaround created one variable. If i want to use compare one date to another date not able to create another date control field.
and FROM_UNIXTIME(created_at)= {{created_at}}
as per one article i went to datamodel and try to select unitxtimestamp this option not showing .
@flamber thanks for reply, sorry for misunderstand. In our mysql created_at column type is text and in queries i am using FROM_UNIXTIME to convert and use for date filter. From datamodel can i change to date and time?
if i continue to use FROM_UNIXTIME how to create 2 date filter variables with same column in report?
@giribm Metabase cannot handle text for dates - all queries would be very slow. You should either use integer or even better a timestamp/datetime instead.
You would have to do something like this if you don’t convert the column: and created_at = TO_UNIXTIMESTAMP({{created_at}})