Eazy Bi : How to Count the issues having same start and end date?

[Rohith reddy]

Hello Community,

I want to see how many issues are there with same start and end date in my EazyBI report. Can anyone please help me out. 

Thanks in advance.

[Martins Vanags -eazyBI- · Accepted solution]

Hi @Rohith reddy 

I have some questions about your requirement.

How are you counting them in the report? will there be any time filters to count these issues in the report? Are you planning to count issues against Time periods? If so, which date picker value (start or end date) would you use to group issue against the time period?

Can you illustrate this better with an example:

let's say you have 5 jira isues:

ABC-1 with start date Jan 1 2023 and end date Mar 31 2023

ABC-2 with start date Jan 1 2023 and end date Feb 28 2023

ABC-3 with start date Jan 1 2023 and end date Feb 28 2023

ABC-4 with start date Jan 10 2023 and end date Feb 28 2023

ABC-5 with start date Jan 10 2023 and end date Mar 31 2023

How would your report look like then?

What dimensions would you put in rows/page filters and what will be expected results in the new "counter"?

Martins / eazyBI support

[Rohith reddy]

Hello,

I have created a new issue without start and end date for it, Then Jira will automatically assigns the same start and end date. 

I want to see in my report, How many issues are there like that so I can keep track of the issues.

Like I want to see if the start date and end date are same it should Count as 1 

In rows, I have taken issue

Hope this is clear.

Thank you :)

[Martins Vanags -eazyBI-]

Try this formula for your calculated measure:

Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
DateCompare([Measures].[Issue start date],[Measures].[Issue end date]) = 0
),
CASE WHEN
[Measures].[Issues created]>0
THEN
1
END
)

Martins / eazyBI

[Rohith reddy]

Thank you Sir, It is working but one problem it is showing in the format mmm dd yyyy instead of 1

[Martins Vanags -eazyBI-]

eazyBI was not able to gues the default output format correctly

for these manual calculations you need to select the "integer" output format for the calcualted measure.

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Formatting