Count how many times an embedded field has the same value

Question

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

Page 1 / 1

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.

Sign up