5 Replies Latest reply on Aug 17, 2016 5:35 PM by kettan

    Calculation inside a measure

    Federico Armentano

      Hi all. I know is easy to do calculations between different measure with Tableau, but what about calculation with one measure?

       

      I have an ID Row field that it is supposed to be correlative (1,2,3,4,...). I would like to programm a filter that detect skips (1,2,3,4,6).

       

      I thought that I can do this with a calculation "[ID Row] - [ID Row(-1)] - 1" but I do not know how to it. Then is easy to do the "if" filter to detect differences that are not equal to 0.

      In the case I was not clear, Attached is an excel workbook with the ID Row field and the expected result in tableau highlighted.

      Thanks all!

       

       

      Federico