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.