graph error

[master_student]

Hello community,

I have a date field in my database that containes date and time as you can see bellow :

I would like to create a graph using that date but the problem as you can see bellow is that the same date is reapeated many times

Any idea please??

Thanks

[sunny_talwar · Accepted solution]

May be use this as your dimension:

Date(Floor([Date de creation]))

[sunny_talwar]

Alternatively you can also create a only date field in the script:

LOAD Date(Floor([Date de creation])) as DateField,

          [Date de creation]

FROM ....

and then use DateField as your dimension

[master_student]

Thanks Sunny.