I'm trying to build a line chart that displays trends by date. I use the following script for the dimension.
=Date(Floor(std),'DD-MM-YY')
The data type for field std is timestamp. It has a time component to it as well.
When I apply a month filter, everything looks fine; only dates are displayed. However when I apply a Week filter, 12:00 am and 12:00 pm are displayed along with the relevant dates on the X-axis.
What possible modification do I need to do in order to display date only without time.