Basic filtering by Specific team members - how to do it

Questions & Answers
1

Hello.
As I’m new maybe that will be trivial question for you so hope to get answer and recommendations.
I’m creating first reports using eazyBi and would like to pre filter my report of time logged by team members. The problem is that in one project there are different teamers and people who are not only part of my team.
What I would like to have is to have some Own filter named like Team in which I will add my team members and can pre filter the data only by members of my team to not see hours logged by other jira users.
How to do it in a best most efficient way?
Thank you in advance for your support.
At the moment I have added my team members as bookmarks.

2

Hi Dawid,
Welcome to the eazyBI community!

You can create a calculated member in the “Logged by” dimension to group your team members together using a formula like:

Aggregate({ 
  [Logged by].[TeamMember1], 
  [Logged by].[TeamMember2], 
  [Logged by].[TeamMember3] 
})

I suggest using autocomplete after the bracket to choose precise member names.

This calculated member can then be used in multiple reports:

  • As a filter in report pages
  • In report rows/columns
  • In other calculated measures

See more about Calculated members in the documentation.

Best,
Ilze

3

Hi Ilize.
Thank you for you proposal.
I have created Calculated Member as my team and agregated all team memberes.
Few questions about it after reading some documentatieons and other threads:

  1. How to drill into selected Group? When I unchecked All and let only selected my Team it is still showing values from other people
  2. If I would like to use this define new calculated member - how I can refer to it from any other dimension? When I try to use it it is showing me usually some errors so I assume I’m doing it in a wrong way.
  3. How to show in a best way days when the time was spent so I can sum them up on a weekly basis and daily basis
  4. Last at the moment point - I noticed that time reported in Jira for a specific day when it is not logged same day it is showing in EazyBi as a day when it was capture in the system - for example Today I log the time for Yesterday - in report it shows like time spent today even if in Jira I selected start day yesterday - is there an option to fix it?