SQL Server "Date" type and "Group By" options

Get Help
1

I'm using Metabase v44 connected to SQL Server. My field "Date Period" is just a DATE type; not a DATETIME. Metabase is showing time options (Minute, Hour, Minute of Hour, etc.) in the Group By list and the default is Minute. This make no sense in my use case. I've tried most of the Metabase semantic type options. Is there a way to fix this so time options don't appear?

image

image
image1212×156 9.35 KB

Thanks in advance for any suggestions.
Regards,
Bob

2

Hi @rleroy
It has been difficult to handle the binning options for all the different database types, so we are currently showing all options to avoid not showing options in some cases, which would prevent some people from binning at all.

3

Ok, thanks for the quick reply.