I'm working on a query where I'm trying to show the weekly report. When I generate the report, it is displaying the days between the weeks which is taking too much space and I don't want them to be the chart as I was doing weekly report.
This is my query :
select trim(array_to_string(a.model,' and '), '') as Model, count(a.model),MAX(timestamp)
from tap_coverage.devices a INNER JOIN
(select DATE_TRUNC('week', timestamp), model, MAX(timestamp) AS max_timestamp
group by DATE_TRUNC('week', timestamp), model
ON a.model = b.model
AND a.timestamp = b.max_timestamp group by a.model,a.timestamp order by timestamp
In the chart generator of the redash: for X-Axis I was doing Datetime and for Y-axis I was doing linear.