search

ClickHouse / metabase-clickhouse-driver

ClickHouse database driver for the Metabase business intelligence front-end
Apache License 2.0
461 stars 84 forks source link

Broken grouping for Day of Week, Hour and Day of Month #155

Closed sergem155 closed 1 year ago

sergem155 commented 1 year ago

When setting grouping to Day of Week, Hour and Day of Month X-axis is not sorted and, in case of Day of Week, displays numbers instead of day of week names.

Screenshot 2023-04-04 at 5 32 46 PM Screenshot 2023-04-04 at 5 32 32 PM Screenshot 2023-04-04 at 5 32 06 PM
sergem155 commented 1 year ago

Metabase show similar charts from MariaDB without issue.

sergem155 commented 1 year ago

Just to clarify - the data is thousands of phone calls to a business, they should be nicely distributed over all charts above.

slvrtrn commented 1 year ago

@sergem155, it should be fixed in 1.1.6