Filter Unique Values in one visual but keep all data for others

Hi,

I'm trying to create a histogram which is showing the Net Volume for different Working Hours of machines. Machines come into service, and for each service occassion the machine hours are registered, and a Service ID number is created. The data table is including multiple rows of the same Service ID, one for each part being replaced in the service. I would like to filter out the unique rows based on Service ID.

I saw a work around to filter out unique values in the Query Editor. However I still need all rows for other visuals, so that method wouldn't work for me at this time.

Many thanks for your inputs.