Summary Report that counts occurences of multiselect items
In addition to [type] and [category] we have [key terms] attached to [cases]
Key Terms are not a relationship but are a tag applied,
Key Terms are held in a seperate table {key terms}
The [key terms] field is a multi-select text field which draws it data from the {key terms} table
Some Cases will have 4 key terms eg
[Case 1]: (topic a) (topic b) (event 1)
[Case 2]: (topic a)
[Case 3]: (topic b) (event 1)
The Case records shows these as a list in the field but a summary report (with date parameters and based on combining equal values in the Key Terms field) sees these as different.
I want a report that counts key terms that have occurred so the output from above would be
Topic a = 2
Topic b = 2
Event 1 = 2
rather than seeing each set of terms as distinct. Do you think this is possible? bearing in mind that we will have around 50 new terms created per year and anyone could feature at any time
------------------------------
Owen Morgan
------------------------------
Key Terms are not a relationship but are a tag applied,
Key Terms are held in a seperate table {key terms}
The [key terms] field is a multi-select text field which draws it data from the {key terms} table
Some Cases will have 4 key terms eg
[Case 1]: (topic a) (topic b) (event 1)
[Case 2]: (topic a)
[Case 3]: (topic b) (event 1)
The Case records shows these as a list in the field but a summary report (with date parameters and based on combining equal values in the Key Terms field) sees these as different.
I want a report that counts key terms that have occurred so the output from above would be
Topic a = 2
Topic b = 2
Event 1 = 2
rather than seeing each set of terms as distinct. Do you think this is possible? bearing in mind that we will have around 50 new terms created per year and anyone could feature at any time
------------------------------
Owen Morgan
------------------------------
