How can I count by day: Items in date format: (dd/mm/aaaa hh:mm:ss)

[jmarinesc]

Hello Comm...

I need  to build a chart counting by day, but my source date format is: (dd/mm/aaaa hh:mm:ss).....

Thanks a lot...

Best Regards

[#2]

count(distinct DAY(DATE#(YOU_DATE,'DD/MM/YYYY hh:mm:ss')))

[#3]

Hey Jaime,

You can try adding calculated dimension like that:

Date(Floor(CREATION_DATE))

But it is better to Aggregate your data during data load.

BR,

Kuba

[MarcoWedel]

another calculated dimension:

DayName(FECHA_SERVICIO)

hope this helps

regards

Marco