Date field not working properly

[suvechha_b]

Hi All ,

How to show the date_created as '2018-07-25'  as it got 3 different timestamp.

My requirement -

to show  '2018-07-25'  on one line as it is a pivot table instead of three line coming ,

I used this set analysis in dimension

=Date ( Aggr(Min(TOTAL <batch_ref> (date_created)), batch_ref, (date_created)) )

, but still getting three rows .like this

Thanks .

[sunny_talwar · Accepted solution]

Convert your timestamp to date using a calculated dimension

Date(Floor(date_created))

[mtucholski]

Hi,

please change the topic so it would serve it's job.

When it comes to your question, try this one:

floor(date_created)