I have a table that are songs that we have worked, the artist, and other information. There are many duplicates as it is possible we work the same song and artist multilpe times. I want to create a view to show unique values only in the artist column. The way we have this set up with the API, Related records does not make sense in this instance.
I know I can group by artist, but it is just not clean or prety. How can I create a view that just has unique values of a specific column?