Hourly data, showing only date on x-axis

[#1]

Hi,

I have hourly data on a line chart, and I'm using calculated dimension to show only date on the x-axis.

=date(MyDateTime, 'dd/MM/yyyy')

This gives me hourly data without having timestamps on x-axis.

Is there any way to show only distinct dates on the x-axis, instead of having the same date repeat as many times as it fits in the chart?

[Anonymous]

Covert this timestamp to date in script itself and create a new field,

Then using new field will resolve your issue.

[ashfaq_haseeb]

Hi

write the below code in your backend.

date(floor(MyDateTime)) as NewMyDateTime

Use this field instead.

Regards

ASHFAQ

[#4]

Won't this give me datapoints only for each day instead of each hour? I want smooth line of hourly data, not straight lines just for each day. But I want the x-axis legend to only have dates instead of timestamps (hours).

[Anonymous]

Can you upload some sample data....

[#6]

I hope this image clarifies what I'm trying to do

[ashfaq_haseeb]

Hi,

Try my solution. It must work.

Or just share your sample app.

Regards

ASHFAQ

[Anonymous · Accepted solution]

PFA

Hope it helps

[#9]

Yes, this is what I'm looking for

I'm quessing the "overlay" trick is the only way to achieve this?

[Anonymous]

Yes I think so