2 Replies Latest reply on Feb 19, 2018 6:41 AM by Jim Dehner

    Alternate to lookup

    Roisha Pal

      Hi Guys,

       

      ZN([Distinct Count of id]) / LOOKUP(ZN([Distinct Count of id]), -1)

       

      without using this lookup how can I achieve this calculation?I do not want to use Compute function.

        • 1. Re: Alternate to lookup
          Mihai Constantinescu

          What are you trying to achieve, we need more details? What is the rate that you want to compute? At what level (dimension/partition) are you counting the ids? You could try and achieve this using an LOD ...

          • 2. Re: Alternate to lookup
            Jim Dehner

            Hi

            Your calculation is based on a position in the underlying table that supports the viz -   using an excel analogy the calculation is saying starting at the current cell move up one cell and take that value to use as the denominator

            you could use Previous value to accomplish the same thing but it to is a table calculation

             

            Table calculations are the tool that tableau uses to move around a table - is there a reason you want to avoid the table calculation -

             

            Jim