Limiting Subquery results - how?
Our implementation of Yellowfin is integrated into a case management software known as I-Sight. The case management software has a table for cases and many tables that connect to that case ID.
I find myself wanting to have a case level report but with the most recent datapoints from some of these other tables. For example, I want to see the case number etc, but I also want to see the most recent note.
I have tried to do this a few ways but none of them work. The simplest way I would think would be to have a Query for the case level data and then a subquery that has a filter and returns the data from MAX date only. However when I do this, even though the filter is in the subquery, the date it is filtered to is from the master. Example, I have 10 cases and one of them has a note from today and no other one does. Because today's note is the most recent that case will show today's note; which is as expected but all other cases will show blank because they have no note from today. The expected result is that each case would show a note with the respective max date on the note for that case.
I'm not sure which version of yellowfin it is, I can't seem to find it in our integration. I can ask the vendor though if that seems important.