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

# Alternate to lookup

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

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

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