4 Replies Latest reply: Mar 10, 2012 2:32 AM by Henco van Ee RSS

    Number format time function

    Henco van Ee

      Hi all,


      From the Google Analytics API I get total visits and total time on site. When I divide the total time on site by total visits I expect the average time on site.

      But, and here is the question, the total time is: 1.014374E7. This number supposed to be the total seconds. But when I make an expression timeOnSite / visits it doesn't work.


      I have already tried to format it into: interval(num#(metric_timeOnSite, '#.#' ,'.',',')/(24*60*60),'h:mm:ss'), but that gives me null.


      Any thoughts on this? Thanks in advance.