title: Is it possible to create a filter that filters out distinct values in a dataset?
body: <p>I'm trying to create a report that will contain two pie charts. I get the data for the report from SQL. 
  Currently, I created a dataset for the first chart which holds records with the following fields: Import ID, Date, Status. This dataset contains duplicate records. 
  For the second chart, I need the same data I have in the first dataset, only without duplications and aggregated differently. 
  I realize that I can create another dataset that will get the distinct values from the SQL database, but I was wondering if there was a way to use the built-in filtering functionality to filter out the dataset I already have to return only distinct values (based on ID field). 
  Looking at the options in the following filtering dialog, I see no obvious way to do this:</p>
  
  <p><img src="https://i.stack.imgur.com/MmMRf.jpg" alt="enter image description here"></p>