Parent/Child Table Filtering

[mikeoshields]

I'm sure this answer is already in here but I haven't found it yet.  I have two tables in a parent/child relationship.  When I pull a single record from the parent, I want to also get all of the fields in the row from the child that is related by ID and where the timestamp = max(timestamp).  Any help would be appreciated.

[sturlaws · Accepted solution]

Hi @mikeoshields ,

you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.