First() and Last()

When working with table calculations requires you to know where you are in a table and how things are calculated one of the tools needed is some sort of indexing, there is an Index() calculation but I've found that first() and last() have been more useful for me. They look at where the position is based upon either the first or last element in a partition. Here is an example where we are calculating based on table across.

 

  1 2 3
  A B C D E F
First() 0 1 2 3 4 5
last() 5 4 3 2 1 0

and then pane across

  1 2 3
  A B C D E F
First() 0 1 0 1 0 1
last() 1 0 1 0 1 0

these two functions have the most use when paired with another powerful table calculation the lookup as we will see in part 3.

Hopefully this short look at first() and last() has been helpful subscribe to @cloudstream_uk for more #TodaysTableauTip

Free Alteryx Trial!

Free Tableau Trial!

Get in touch with us today!

Contact us
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
More information Ok