HOTSPOT -
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
To display the count of Returns only for the first year in the table, we need to use a function that identifies the first row in the partition. Both FIRST() and INDEX() can be used for this purpose, but the correct way to compare with FIRST() is through its comparison with 0, which means the first row. Therefore, the correct formula is: IF FIRST() = 0 THEN COUNT([Returns]) END. This will ensure that the count of Returns is displayed only for the first year in the given table.
The answer is incorrect. You can't compare date and integer values. The correct answers can be First() = 0, or Index() = 1. Both would work on a filters page to return the first year.
First()=0
The answer is FIRST(). I tried it using sales. IF FIRST()= 0 THEN SUM([Sales]) END
First() = 0 gives you a boolean(true) which shows you the first year of count of orders