Unable to group by month, day, week etc

Get Help
1

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?

image
image1920×531 26 KB

image
image457×654 17.8 KB

2

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

3
  • Date
4

@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.

image
image1655×186 5.9 KB

5

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

6

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

1 Like