求助：如何在EazyBI MDX中创建统计周六创建Issues的Member

Hey there! Since you're new to EazyBI and Jira, let's walk through exactly how to build that member to group all issues created on a Saturday.

Step 1: Access the Calculations Editor #

In your EazyBI workspace, head to the Data tab and select Calculations. We'll create a new calculated member in the Issue dimension (this is the most straightforward spot for aggregating specific issue sets).

Step 2: Use This MDX Code for Your Member #

Aggregate(
  Filter(
    [Issue].[Issue].Members,
    DatePart("w", [Issue].CurrentMember.get('Created at')) = 7
  )
)

Let's break down what each part does: #

• Aggregate(): This function takes a filtered set of issues and rolls them into a single, usable member—perfect for grouping all Saturday-created issues together.
• Filter(): This narrows down the full list of issues ([Issue].[Issue].Members) to only those that match our criteria.
• DatePart("w", [Issue].CurrentMember.get('Created at')) = 7: This checks the day of the week for each issue's creation date. In MDX, DatePart("w", date) returns 1 for Sunday, 2 for Monday, ..., 7 for Saturday—so we target values equal to 7 to capture only Saturday-created issues.

Alternative: Create a Measure to Count Saturday Issues #

If you'd rather have a numerical count of these issues instead of a grouped member, you can add this measure to the Measures dimension:

Count(
  Filter(
    [Issue].[Issue].Members,
    DatePart("w", [Issue].CurrentMember.get('Created at')) = 7
  )
)

Quick note: Make sure the "Created at" field is included in your EazyBI data import—if it's missing, you'll need to go back to your data settings and enable it first.

内容的提问来源于stack exchange，提问作者Martin Gattermann