I have seen other users post with the same question, but its been a year since the most recent thread so I am hoping I can get something that's come along more recently.
We have created an APP that collects "Task Requests" as individual records, within each task request there is a selection list where the user selects relevant quality escapes. Then we want to create a bar-chart that displays a sum of all quality escapes by month. The table will say: January -- 3 apples, 2 oranges, 2 bananas. Feb -- etc...
For example: on task request #001, I have selected apples, oranges, & bananas as my quality escapes. the table then creates a new record per the following: "Apples....ananas" 1. Whereas we want the tool to just 'bump' all of the existing records by one instead of creating a new record that is unique to that combination of escapes.
I hope this makes sense!