Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Convert your timestamp to date using a calculated dimension
Date(Floor(date_created))
Convert your timestamp to date using a calculated dimension
Date(Floor(date_created))
Hi,
please change the topic so it would serve it's job.
When it comes to your question, try this one:
floor(date_created)