Summarise by day or month

In my metabase notebook, I am trying to get the number of distinct dates in a datetime field.

Metabase allows me to summarise by week, but it is possible to change this to month or day?

In the group by section, we can easily make this change but in the summary section, week is auto selected for me and I do not see the option to choose.

Thank you!

Hi @yxteh
When you select the distinct field, then you get the option to select binning:

@flamber, I dont see it on my side :frowning:

Is there something I need to do to enable this?
Currently running metabase 0.42.4 locally in a docker container.

@yxteh Binning of metrics was only added in 43. https://github.com/metabase/metabase/releases/latest

1 Like

Hello everyone. Is there a reason why not all dates can be grouped by month?

Checked the field types as an admin and they are both dates but somehow not both can be grouped monthly

i.e.

please post diagnostic info

I am having the same behavior here, curious to know when this "by week/month/day" should show up? if the table metabase looks like the same?

Please post diagnostic info, what data type is that field in the db?

I am not sure where I can find the diagnostic info, can you help me out?

I solved this by changing a bit the format using SQL:

STR_TO_DATE(datetime, '%Y-%m-%d') as dateTime

@Luiggi data type is "Creation Time".

Would still be nice to understand what are the conditions that make this "by week/day" to show up. @flamber would you happen to know the conditions for that?

Thank you everyone!