Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Aug 27, 2020, 1:35 AM

I've tried to round a Timestamp field to a nearest minute and created the calculated field using the below formula (kindly posted on the web), but the results has a mismatch. Sample data attached.

1st column is system timestamp.

2nd column: Calculated field 'DateTime Rounded Minutes' using the formula :

DATETIME(INT ([DateTime]) + (Round( FLOAT([DateTime])%1*1440 ) /1440))

I'm getting the following mismatch. Please help to fix this.

I've tried to round a Timestamp field to a nearest minute and created the calculated field using the below formula (kindly posted on the web), but the results has a mismatch. Sample data attached.

3 answers
  1. Hari Ankem (7x Tableau Ambassador)
    Aug 27, 2020, 2:51 AM

    You can do it this way:

    DATETRUNC("minute",[DateTime])

    +

    IF DATEPART("second",[DateTime])>=30 THEN

      1/1440

    ELSE 

      0 

    END

     

    You can do it this way:DATETRUNC(=30 THEN 1/1440ELSE 0 END Hope this helps." style="display: block;" />

     

    Hope this helps.

Write an answer...
0/9000