Aggregate functions first() or last() do not work as expected
Summary
first() should return first value of the aggregated column, but if the value is No Value, it actually returns the next value that isn't No ValueContent
Here is how I expect the function to work. Imagine the following data set - Contact inner join with Incidents:
| Contact ID | Incident ID | Product ID | Date Created |
|---|---|---|---|
|
100 |
1 | No Value | 7/1/2019 |
| 100 | 2 | B | 8/1/2019 |
| 100 | 3 | C | 9/1/2019 |
I only want to return data from the earliest Incident for a Contact. So I put the aggregate function in columns 2-4 like so: first( [column name], Date Created). I'm expecting the report to return all columns from the first row, but instead, I get this:
Tagged:
1