Dashboard Reports - Count of attributes that match each other

Andrew Davenport

Hi All,

I would like to be able to create an action query to show on a dashboard the count of a set of attributes.

In this case I have set up attributes in action tracks with course a, b, c and location a, b and c for example.

I then want to show on the dashboard result of a query that totals up the number on constituents on course a in location a, course a in location b, course b in location a and so on. Example:

10 - Study Skills - Plymouth

9 - Workshop Skills - Exeter

17 - English - Weymouth

At the moment I have to export the results and sort in excel.

If developers are reading this it would be a basic function to add.

If anyone has found a way to do this I would love to know.

Thanks