how to return first row of data

[mandy_chan]

The problem

Let's say you have a table like so:

And you want to return only the first row of data in a single column.

The solution

We can accomplish this by using this function here:

pivot_index(index(${number_of_sign_ups.count}, 1), row())

The explanation

Index(orders.count, 1) is specifying to return values from the 1st row, and pivot_index(X, row()) is saying that for each row that exists, return the value within the index function that corresponds to the pivoted column matching the row number.