UNIX timestamp in filter box.

[tree1123]

Hi guys, i'm use Superset 1.3.0 and i am getting the UNIX timestamp in filter box. Could you please suggest how to resolve it.

i expect 2021-01-01
2021-01-02

[srinify]

Hi @tree1123 for the community to help you out, we will need a LOT more context :)

• What version of Superset are you using?
• Which database are you using?
• What's the column type for the created column?

Issues with #2 and #3 often cause the issue you're seeing!

Also keep in mind that filter boxes are being deprecated slowly in favor of Dashboard Native Filters: #12148

[tree1123]

Superset 1.3.0
mysql
column type in mysql is datetime,and in superset is timestamp no zone

[villebro]

Hi @tree1123 - Filter Box is currently in the process of being deprecated and replaced by native filters, and therefore I don't believe this will be fixed (however, community contributions are welcome!). I urge you to check out the native value filter, which correctly handles timestamps. You just need to enable DASHBOARD_NATIVE_FILTERS feature flag, after which the native filter tab will become visible on your dashboard.

[tree1123]

Hi @tree1123 - Filter Box is currently in the process of being deprecated and replaced by native filters, and therefore I don't believe this will be fixed (however, community contributions are welcome!). I urge you to check out the native value filter, which correctly handles timestamps. You just need to enable DASHBOARD_NATIVE_FILTERS feature flag, after which the native filter tab will become visible on your dashboard.

i understood。thank you