Grouping Date & Time by Date on Axis

[Nogi]

My current graph: https://imgur.com/a/MRCKS

The X axis looks way too condensed. Is there a way to clean that up so that you can still see the date and the times? Like showing in groups of dates?

[honeybakliwal]

There are 2 ways to achieve this 

1) You can convert the date time to date in sql query iteslef and create  a group of that field in  the report  and pass the date field to the chart rather then datetime.

2) Other way to achieve this if you can not change the query, in that case create a new variable and convert the datetime field to date datatype and then use that variable for grouping and passing to the chart 

 

Regards

Honey