3 Replies Latest reply on Dec 13, 2016 7:31 AM by Andrew Watson

    Adding up Interval Time (tableau error)

    chakradhar kakani

      Hello Tableau users,

       

      I'm getting an error in Tableau. I have to add up the total time duration of hours:mins:secs. The Field in database is INTERVAL TYPE but in tableau it came in as STRING, when i have asked my ETL developer he has asked me to SUM up the column but when I convert the field into number and use it in the sheet. I have been getting an error i have attached an screenshot. is there any other work around to sum the INTERVAL time.

       

      Thanks