Unable to group by month, day, week etc

I have a timestamp field "date occurred updated", see image below. When I try to summarize by this field I do not get the options to group by month, week etc. Including an image that shows the timestamp format. What gives?

Is that field a Data or Text in your Schema? Can you share the table DDL

  • Date

@TonyC here you are. It was a date field before I started trying to troubleshoot, so yesterday I'd changed it to a timestamp field.

I mean on your schema not on metabase ... Metabase type is simply visual if you set that as date but then the actual column is a number things will start breaking

You are right. I can see in the original schema it was sent a string text, so I am adjusting the source.

1 Like