Group By View to create a view with unique values (and a count)

[vanderLeest]

I want to create a view that will give me unique values for an activity with an entity, while the table stores activity, entity and sometimes  multiple contact persons per entity.  I want a chart and a report that shows the number of activities with each entity (and do not want those entities with multiple contact persons to count / shown multiple times).  Is there a way to create so-called Group By views, or is there a way to structure a report in such way that The multiple contacts are not shown?

[Vitalikssssss]

Hi vanderLeest,

 

Perhaps you can use a Pivot table datapage which can give you the desired output and layout.

 https://howto.caspio.com/getting-started/create-a-pivot-table-report/

Hope this helps.

vitalikssssss