How to get the single date count by adding all the dates with time stamp.

[vishalgoud]

I have a date field wtih time stamp and counts for varie on each time.

ex:              date ,                    counts

24/10/2017 09:06:36 , 35

24/10/2017 11:06:36 , 75

24/10/2017  12:06:16 , 15

25/10/2017 09:06:46 , 65

24/10/2017 12:06:36 , 95

Now i want the date fileds should contain single date with out timestamps so that if i select it will give a sum of all the counts to that particular date :                        24/10/2017  - 125

                                                 25/10/2017  - 160

is should be like a filter in the UI, Like week and year filters..

[sunny_talwar]

Create a new field like this

Date(Floor(date)) as Date,

date as TimeStamp

and then use Date as your dimension and same expression

[florentina_doga]

pls see attach