Count new project without measure issue

Questions & Answers
1

Hello everyone I am really new to the easyBI and currently looking for help, how could we count project created without using the [Measures].[Issues created] ? Because I want to count the new project weekly. if using the measure issue created it would show redundant data almost every week whenever you create a new issue on the same project in different week. So the old project would appear again

please help, thanks

image
image1123×618 35.4 KB

2

Hi @Arsy ,

If you want to see each Project dimension member only on the Time dimension period once - in the period its first issue was created, you can define a calculated measure with the formula below:

CASE WHEN
DateInPeriod(
([Measures].[Transition to status first date],
[Time].CurrentHierarchy.DefaultMember),
[Time].CurrentHierarchyMember
)
THEN 1
END

It will look for the first transition to status date in the particular Project and return a 1 if it is the current Time dimension period. See a screenshot of the report below:

Screenshot 2021-06-10 at 18.40.16
Screenshot 2021-06-10 at 18.40.161722×812 73.5 KB

See more details on defining calculated measures in the eazyBI documentation page - Calculated measures and members - eazyBI for Jira.

Best,
Roberts // support@eazybi.com

3

Hey Roberts,

thanks for your help, but I think I still need a lil bit help here why does this happen?

image
image304×571 3.46 KB

thanks

4

Hi @Arsy ,

Sometimes eazyBI guesses the wrong formatting, depending on the functions used in the formula. Try to change the formatting of the calculated measure to integer - Calculated measures and members - eazyBI for Jira.

Best,
Roberts // support@eazybi.com

5

ok thank you Roberts