I have a little problem with my graph, I have duplicate values as dimension and I don't understand why.
It's a graph with date of reloading as dimension that i collect like this :
Date(ConvertToLocalTime(ReloadTime(),'Paris'),'DD/MM/YYYY') as date of reloading.
And as one day i reloaded multiple times i have multiple values of this day as dimension.
I supposed this is because Date is only a function who is useful for displaying date but not really to convert date ? So As ReloadTime contains also hour/ minute / second, the values are different but as they are showed only as DD/MM/YYYY they look the same.
I was so wondering what would be the best way to convert them to dd/MM/yyyy only ?