enter image description here enter image description here I wanted to get the distinct names and percent of the latest record(latest record by date)
