Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Covert this timestamp to date in script itself and create a new field,
Then using new field will resolve your issue.
Hi
write the below code in your backend.
date(floor(MyDateTime)) as NewMyDateTime
Use this field instead.
Regards
ASHFAQ
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).
Can you upload some sample data....
I hope this image clarifies what I'm trying to do
Hi,
Try my solution. It must work.
Or just share your sample app.
Regards
ASHFAQ
PFA
Hope it helps
Yes, this is what I'm looking for
I'm quessing the "overlay" trick is the only way to achieve this?
Yes I think so