I have a big query data set that i imported into looker. Fields of import are the following:
- issueKey (text)
- updateDate (date)
- sprint (number)
- maxUpdateDate (calculated field formula: MAX(updateDate) )
- maxSprint (calculated field formula: MAX(sprint) )
I want to get only the records, per issueKey that have the last updateDate and last sprint for each.
I created a blended data set, with the same table in between the two tables, set to INNER JOIN
the links are as follows
issueKey - issueKey
updateDate - maxUpdateDate
sprint - maxSprint
However I am still getting records that have an updateDate that is not the max value, although for some reason the records that do not have the max sprint were correctly excluded
Is something wrong happening or should I fix something?