Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
May i have the way of removing date timestamp from chart?
Data is as follow
Data source in excel as follow
You can try this either in the Script (recommended) or when using the dimension:
Dimension:
=Date(floor("Date"))
Script:
Date(floor("Date")) as YourDate
Regards,
Sorin
Script is not usable in my environment, as it needs to be used by management. and the solution is also not workable
Hi
replace your Date dimension with this:
=Date(Timestamp#(Date,'M/DD/YYYY hh:mm TT'))
remove the continuous axis property (set it to "No")
Just as update, none of suggested answer is working. I'm still trying to solve.
can you show us output of your expression after putting it into calculated field..???
Date(Floor(Date),'M/DD/YYYY')
If possible share your sample app.
Regards,
Date(Floor(YOUR_FIELD))