I am writing a custom sql query. When I use the Date(created) sql function and group by date(created) I cannot visualize the data through Metabase. It gives me the issue
“We couldn’t create a line chart based on your query.”
An example of this query would be
SELECT Date(created), count(*)
GROUP BY DATE(created)
I think the problem is that the backend is not returning a base_type for the calculated field so the frontend doesn’t know it’s considered a metric. I think the backend should set the base_type depending on the calculated column’s formula.
Similar issue here