Create the custom measure to get the project roles count

I have to get the two project roles count (Developers and QA) individually which role spends the time on Jira issues. Kindly help me with this

Hi @VNRajuVallabhaneni ,
Unfortunately, eazyBI currently does not support the import of project roles. We have this feature in our backlog, and I will upvote it with your request.

There are two possible workarounds.

  1. using Jira user groups instead.
    If each project role also has a separate Jira user group, then you may import Logged By Groups, Assignee Groups, and Reporter Groups and use them instead of user dimensions: Data from Jira

  2. Import project roles from an additional data source (perhaps, SQL Select directly from Jira): import them as user property to Assignee, Logged by or Reporter dimension and then use this new property to create calculated members in the particular user dimension for each role.
    Read more about additional data import: Additional data import into Jira Issues cube

best,
Gerda // support@eazybi.com