I have a data set that has embedded data and I want to display a sum of the same embedded data field in my dashboard.For example:my embedded data field is text field Companyand I have the following response data:Company 1 employee X Company 2 employee X Company 1 employee Y Company 3 employee XIs there a way I can show in my dashboard that:Company 1: 2 employees responded Company 3: 1 employee responded etc Many thanks for any adviceRegardsJo

Question

Count how many times an embedded field has the same value

I have a data set that has embedded data and I want to display a sum of the same embedded data field in my dashboard.

For example:

my embedded data field is text field Company

and I have the following response data:

Is there a way I can show in my dashboard that:

Many thanks for any advice

Regards

Jo

+22

You can use a Pivot table widget to achieve this. Rows will be company name and columns can be either count or sum based on your data.