min date_created not showing correctly

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Please kindly assist ,

How can I get the min date_created in the below dimension . I don't want the timestamp of the date_created .

Currently I used this -

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

But it showing me with timestamp.

Even if I used -

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

it is not showing the timestamp but coming in two different line .

My requirement is -

Application Date should reflect 2018-07-14 in one line

Thanks,

Re: min date_created not showing correctly

sibin_jacob — Tue, 31 Jul 2018 07:17:29 GMT

Hi Bhadra,

Please use the floor function before to Date function

Date (

Floor(

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

))