I have data that are structured as so:
| Node | Update Datetime | Measure Values |  
|------|-----------------|----------------|
| A    |  2018-01-01     |  1             |
| A    |  2018-01-05     |  3             |
| A    |  2018-01-06     |  4             |
| B    |  2018-01-02     |  2             |
| B    |  2018-01-03     |  4             |
The nodesare updated over time with the measure values showing the node's value at the time of data entry, meaning just filtering on a date range will overstate the node's value. The report needs to be responsive or else I would just do this in sql, but as it stands I need to be able to keep only the rows that contain the maximum datetime value within each node, after the entire dataset is filtered on a general date window.