1 Reply Latest reply on Oct 10, 2018 3:35 PM by Shinichiro Murakami

    use of Total load time vs elapsed_time in default admin views

    Krishna Bellam

      Hi Team,

       

      Can someone clarify on below question?

       

      In "Stats for load times" sheet of Tableau admin views we noticed that they have used Total Load time instead of elapsed time. Here are the formulas for both.

       

      Request_Code:

       

      if startswith([Http Request Uri],"/views/") or startswith([Http Request Uri], "/vizql/showadminview/") then

        1

      elseif contains([Http Request Uri],"/bootstrapSession/") then

        2

      elseif contains([Http Request Uri],"/status/") or contains([Http Request Uri],"/errors/") then

        3

      else

        0

      end

       

      agg_request_length:

       

      if LOOKUP(MIN([request_code]),0) == 3  AND LOOKUP(MIN([request_code]),-1)!=3 then

        // The length is computed from the start of the previous

        (MAX([Completed At])-LOOKUP(MIN([Created At]),-1))*86400

      ELSEIF LOOKUP(MIN([request_code]),0) == 3  AND LOOKUP(MIN([request_code]),-1)==3 then

        // The length is computed from the start of the previous

        (MAX([Completed At])-LOOKUP(MAX([Completed At]),-1))*86400 + PREVIOUS_VALUE(0)

      ELSEIF LOOKUP(MIN([request_code]),0) != 3  AND LOOKUP(MIN([request_code]),-1)==3 then

        // The end of an async operation

        (MAX([Completed At])-LOOKUP(MAX([Completed At]),-1))*86400 + PREVIOUS_VALUE(0)

      ELSE

        86400*(MAX([Completed At])-MIN([Created At]))

      end

       

       

      Total Load time:

       

      ZN(Window_SUM([agg_request_length]))

       

      elasped_time

       

      [Completed At])-[Created At]

       

      We would like to understand why they have taken Total load time and table calculation instead of taking elapsed_time directly. Any suggestions? Any advantage or difference in using Total load time here?

       

       

      Thanks,

      Krishna