Hi All,
I tried a query in ROVO to analyse last months issues in JSM (around 1400) and provide a summary table with keywords/categories and the number of issues for each category. It took me a bit of screaming and cajoling but eventually ROVO gave me the table with the categories and the number of issues and it looked great.
I tried to do the exact same thing (i copied and pasted the original query but changed the filter for a list of around 600 issues) but no matter how hard I try or scream or rephrase, I cannot seem to get ROVO to give me a table for all the results. It is stuck at analysing on 40 issues or sometime 38, but never listing the full results in one table like the first time I tried.
My query looks like this:
Analyse ALL the issues in [JQL filter on my service project] to extract keywords from the Summary and Description fields then categorise them based on these keywords.
Use the following strategy to analyse them:
For each issue, retrieve the summary and description.
Analyse the text for keywords and group issues into categories (up to 5 words per category).
Count the number of issues in each category.
Present the results in a two-column table: Category | Number of Issues.
Ensure the total number of issues in the table matches the number of issues returned by the filter.
DO NOT generate a table that only shows a subset of the issue. The table MUST categorise all issues
Any suggestions for making this work. I'd like to re-use this process in future for reporting purposes.