Skip to main content
brainerd_daria
brainerd_daria
Contributor ⭐️
October 20, 2016
Question

Can you exclude duplicate customers when Reporting on CTAs or Projects?

  • October 20, 2016
  • 1 reply
  • 114 views
I am trying to run reports for all customers with a priority red CTA so I can show ACV impact/quarter. Some of our customers have multiple code red CTAs, so it inflates the ACV value and count of customers. How can I remove duplicates from within the engine or dashboard? Right now I'm manually correcting this in excel. Thanks! 

    1 reply

    manu_mittal
    Gainsight Employee ⭐️
    manu_mittal
    Gainsight Employee ⭐️
    October 25, 2016
    One way to achieve this is to do a COUNT of CTAs by Account Name, and then filter for Type = X, Priority = Y. This way you'd get one row per Account along with the number of such CTAs each Account has. Any other attribute you wish to add, such as ACV or Health Score, can also be included as a MIN/MAX aggregation, like so:



    Hope this helps!

    Thanks,
    Manu
    Terms & ConditionsAccessibility statement