Bar char based on SQL with 2 items in GROUP BY

[infofcc3]

How to fix Bar chart based on SQL

Problem statement : My bar chart is based on Postgres SQL: select the_date, name, max(value) as max_value from T where the_date >= DATE(‘2023-08-01T07:00:00Z’) and the_date <= DATE(‘2023-09-01T06:59:59Z’) group by the_date, name order by the_date, name In Bar chart properties I specified X Axis as “the_date” In Postgres table the “the_date” column has type “DATE”. Problem #1: currently the bar chart shows the x-axis labels as several identical values 17:00:00.000 17:00:00.000 17:00:00.…

You can follow our detailed document.