Multiple date lines where loading "Date and Hour" feild

[Ishragil]

Hi

I'm trying to load data about mushrooms picking from a table where the "Date" field, mentions date+hour of picking.

I've created a new Dimension for date, using:

DATE(MAKEDATE(1988) + UDATE/1440,'DD/MM/YYYY')   as  Date,

But the output us several lines for each date (the same amount of lines as if I leave the hour)

How can I consolidate all the lines for certain date to only one line?

Thanks a lot in advance

[Kushal_Chawda]

@Ishragil  what kind of values stored in UPDATE field ? What is expected output?

[PrashantSangle]

for debugging purpose,

can you add  below line in script then run script , add num_Date in chart and share the output.

Num(Floor(MAKEDATE(1988) + UDATE/1440)) as num_date

I just want to check what value it is evaluating?

Regards,

Prashant Sangle

[Ishragil]

It gives the same value for all the lines on the same date

[Ishragil]

[Ishragil · Accepted solution]

I am happy to update that I found the solution from a friend.

the solution is by using the function Datestart(), or to be more specific:

DATE(MAKEDATE(1988) + daystart(UDATE/1440),'DD/MM/YYYY') as Date,