Summarise by day or month

#1

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.

image
image.png676×932 27.4 KB

Thank you!

#2

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

image
image.png454×683 37.5 KB

#3

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

image
image.png952×1734 58.3 KB

#4

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

1 Like