Question

Remove Duplicates from Reports

  • 14 April 2021
  • 4 replies
  • 12 views

Userlevel 2

Hello Team!

I did not see this posted anywhere, we have reports where we would love to see only the unique values.

In Excel you can remove duplicate values, example, we would only want to keep the company name.

Here is my Example:

Name:     Product:                    Start Date:
TBL          C360                          1/1/2021
TBL          Success Plans         1/1/2021
TBL          Renewal Center        1/1/2021
TBL          Scorecards                1/1/2021

In this case, I would want to keep ONLY 1 of the “Company Name” I do not want to see them 4 times.If we were able to remove the Duplicate names to only keep the unique 1, that would be helpful.

And even removing the Product field it will still give me 4 values, since they are in the report 4 times.
 


4 replies

Userlevel 7
Badge

Hi @Ricardogs18 can you explain a bit more on what you are trying to report on? If you just want a list of companies, then you can add the company name to the “group by” and put the product field in the “show me” to get a count of products per company. 

Userlevel 7
Badge

Hi @Ricardogs18 did you figure out your reporting challenge?

Userlevel 2

@dan_ahrens The Group me is a great option, there are some cases where we need to see the various data to see where the changes maybe. A great example is when Opportunity Data is being cleansed or vetted. I can group by the Company Name, but then that just gives me a number of the stages.

Example: 

Name:     Product:                    Opportunity Stage:
TBL          C360                          Closed Won
TBL          Success Plans         Closed Won
TBL          Renewal Center        Renewal
TBL          Scorecards                Upsell

If I grouped the above, I would only get numeric values grouped by the Name I would have to ungroup it and we would still be back at Square one. Exporting and cleansing in Excel.

Data Designer has been helpful to an extent to be able to achieve getting rid of dupes.  However, DD is a little cumbersome in creating and then you have to wait for it to update.  We spend almost 4 hours on a DD that could have very easily been created in less then 30 min if we had a duplicate removal option. 

Userlevel 7
Badge

@Ricardogs18 can you share a visual example of what you would like the final output to look like? This can help me figure out the best way to get that for you. 

 

If you wanted to see a structure like the one you shared, you could do this by putting NameProduct, and Opportunity Stage all into the “Group by” and then adding some other field in the “show me” to be able to aggregate it. 

Name:     Product:                    Opportunity Stage:
TBL          C360                          Closed Won
TBL          Success Plans         Closed Won
TBL          Renewal Center        Renewal
TBL          Scorecards                Upsell

 

 

Reply