On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

accessing a particular row in a data set

lektuvas
lektuvas Junior Member
edited 2020 23 in Designing Analytics Reports #1
Hello,

I have SQL query that returns exactly 8 rows. I want to use a column of the 3rd row of this data set. Is there a way to access a specified row?
Tagged:
Flag · Like

Comments

  • Virgil
    Virgil Administrator EM admin
    edited 1969 31 #2
    There might be more ways to do this but here is one way.

    Add a table (or list) to the report.
    Select the table, and then the Filters tab in the Property Editor
    Add a filter of:

    Expression: row[0]
    Operator: Equal to
    Value: 2 --- (This should return the 3rd row since rows are zero based)

    Oh yeah, then add the column you want to the table's detail section.

    Virgil
    Flag · Like

Categories