How do I get the monthly data for 2 date ranges as 01 to 15 of every month and 16 to 30 of every month?
Row - EPIC & Issues
Columns - Col1( Month date range 1-15) & Col2 (Month date range 16-30)
How do I get the monthly data for 2 date ranges as 01 to 15 of every month and 16 to 30 of every month?
Row - EPIC & Issues
Columns - Col1( Month date range 1-15) & Col2 (Month date range 16-30)
Hi @Jayant_Ghorpade,
You can create a measure that would get the date part of the issue property. For example, I am using “Issue created date”, this is only to test that this expression returns correct dates:
cast(
ExtractString(
Cast([Measures].[Issue created date] as String),
"(\d+)",1
) as NUMERIC
)
Then based on this measure, you can create two measures. One to count issues that are created till 15th date:
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created]>0
AND
cast(
ExtractString(
Cast([Measures].[Issue created date] as String),
"(\d+)",1
) as NUMERIC
)<=15
),
1
)
and the second to count issues that are created after the 15th day.
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created]>0
AND
cast(
ExtractString(
Cast([Measures].[Issue created date] as String),
"(\d+)",1
) as NUMERIC
)>15
),
1
)
In the report then, you can get two columns:
best,
Gerda // support@eazyBI.com