Date Based issues with Filter condition as Sprint Start Date & Sprint End Date

[gvparthi]

Hi eazyBI Community,

I’m trying to create a report that allows me to filter tickets based on the field “Web Live Date” and the selected Sprint.

Here’s the requirement:

• I need a filter option to select a Sprint.
• When I select a specific Sprint, the report should automatically display all the tickets that have a “Web Live Date” falling between the selected Sprint’s start and end dates.

Could anyone guide me on how to set this up in eazyBI?

I getting error in identifyng the tickets with web live date between sprint start date and Sprint End date. Help with MDX Code to figure it out

[zane.baranovska]

Hi @gvparthi,

For this report to see a list of tickets based on the “Web Live Date” falling between the selected Sprint’s start and end dates, you should use calcauted measure as a filter.

1. Add the “Sprint” dimension to the report’s pages to allow selecting a specific Sprint for the report and filter data.

2. Add the “Issue” dimension on report rows to get the list of issues that would fall in the selected Sprint.

3. Create a new calculated measure in Measures to check if the “Web Live Date” is within the Sprint date range:

   CASE WHEN
     DateBetween(
       [Measures].[Issue Web Live Date],
       [Measures].[Sprint start date],
       [Measures].[Sprint end date]
     )
   THEN 1
   END
   

   Set measure formatting to Integer.
   For more details on calculations, see the documentation: Calculated measures.

4. Select the new measure on report columns and filter rows that have a value greater than 0. More details see in the documentation: Create reports.
   You can now remove the column with the calculated measure if you don’t need to see it in the report. The filter criteria will remain.
   

   

Best,
Zane / support@eazyBI.com