7 Replies Latest reply on Nov 12, 2018 9:12 PM by swaroop.gantela

    Advanced table calc and timestamp calc

    Julia.rose

      Hi

       

      I have some table calculations to be done which I usually perform in R but I was wondering if we can do those in tableau directly.

      Have attached sample calculations in the attached sheet. But idea is to

      1) Subtracting two time stamps in each row for each group

      2) Subtracting one time stamp in one row with another time stamp in previous row in another column, for each group

      3) Average of outputs from (1) for every ID

      4) Average of outputs from (2) for sets of nodes.

       

      LOD and lookup couldn't be used together, so that was one roadblock. And I doubt if part 4 can even be done in tableau.

       

      Message was edited : Added location_Id. Previous version had this column missing.sorry about that.