Count unique companies

2 posts / 0 new
Last post
w.mak@tignl.eu
Count unique companies

Hi,

I want to count the number of activtities linked to unique cutomers. So I have 3 appointments with one customer, I want to calculate this as 1 value. How can I do that?

Regards,

Wouter

Erik
Erik's picture
Try using the dContact datatable

Create a visualization based on the dContact data table. Set up the grouping criteria to group by Company and include Nr. of activities using aggregation mesthod to Minimum.
Maybe you need to set a column filter to only show the Companies that have no activities (I dont know exactly what you want to find out...).  Perhaps you want to set some parameters up to limit your selection - usually there are thousands of Companies in the database.

Now you have a listing showing all the Companies and the nr. of activites pr. Company.

 

Log in or register to post comments