Aggregate more than 1000 issues error with issues created measures

[XavierH]

I used to make aggregate of issues using

"agreggate ( Filter (…))

it’s working but i got an error for the whole groupe when using basic measure like issue created.

Why ??

[gerda.grantina]

Hi @XavierH ,
The problem you are encountering is caused by the high number of issues going into the calculated members “US/Enabler/Bugs/Task” and “Feat/EF”. The Mondrian engine has some limitations, and 1000 members for aggregation is one of these.

A better solution would be to precalculate (group) issues with specific text pattern in a summary and import this grouping as a new dimension using a Javascript calculated custom fields.
See a similar use case here with a JavaScript code example:

Filter open issue by summary

Hi @karim , I don’t recommend defining such calculated members in the Issue dimension. They are a performance risk. If you don’t have the option to create a new custom field in Jira, define a new JavaScript calculated custom field in eazyBI. See more details on how to do that here - JavaScript calculated custom fields - eazyBI for Jira. Add parameters similar to the one below to your eazyBI advanced settings: [jira.customfield_developer_issue] name = "Issue summary Developer" data_type = "st…

best,
Gerda // support@eazyBI.com