Want to summarize Products for each months

Questions & Answers
1
Issue(project) Products Issue created Onboarding Start date
Customer x Pro 1 1 Jul 2023
Customer x Pro 2 1 Jul 2023
Customer x Pro 1 1 Jul 2023
Customer x Pro 2 1 Aug 2023
Customer x Pro 1 1 Aug 2023
Customer x Pro 2 1 Aug 2023

So I want this to be show like this instead

July

  • Pro 1 - 2

    Pro 2 - 1

Aug

  • Pro 1 - 1

    Pro 2 - 2

Formel for Onboarding start date is:

| TimestampToDate(
Min(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Issue Start Date])
),
DateToTimestamp([Measures].[Issue Start Date])
)

)
Custom field Import as dimension Import as property
Products Yes Yes

I want to present this report in a Bar view instead for a table

2

Hi, @Coachen

Welcome to the eazybi community.

If you have imported the “Onboarding Start date” field from Jira as a measure, eazyBI automatically creates the measure "Issues with Onboarding Start Date**"** (or a similar name based on your field name).

To show products summarized by month based on the Onboarding Start date, build your report with:

Report structure:

  1. Add Time dimension in Rows (select Month level)

  2. Add Products dimension in Rows (below Time)

  3. Select the measure: “Issues with Onboarding start date.

The built-in measure already counts issues where the date field value falls within each Time period - exactly what you need.

Note: Make sure your date field is imported as a measure in the import options (not just as a property). Check your import settings to confirm the measure is available.

Kindly,

Ilze

3

Hi Ilze

Thanks for getting back to me
Time Dimension for us is when we created our Project (Issue) and not when we start working with it
That´s why we created Measure Onboarding start date. That works for us
Maybe I wrote info what we are after

I want create a report where we can see how many project we start each months / products

Hope this make sense

Br

4

Hi, @Coachen

Please read here how the Time dimension works in eazyBI.

Kindly,

Ilze

5

Hi

I can easily create a report there I present created Date (Time)
But not for Project start date since this not a Dimensions
Its only visitable as Measure, Property and Value Changes
I have looked to that Video you sent me, but it didn’t help me

Is it possible to import Start date as a Dimension?
If so, how do I proceed

Br

Gert