Help creating this chart format

I found this really cool looking chart:

Sprint Timeline

I can’t seem to find how the “Sprint Start date” & “Sprint End date” measures were combined to show the grey bar…any ideas?

Here’s a screenshot of specifically what I’m looking at:

Hi jimbok11,

To achieve this chart type you need two date measures (as shown in the pic Sprint start date and Sprint end date) then follow below steps,

  1. Select any two date measures.
  2. Go to Bar view and click on the Start date legend icon.
  3. Got to type and select “Range” type.
  4. Now you all set and you can see the combined date bars.

Please let me know if you need any additional information.thanks

1 Like

That did it wonderfully, thanks @Ganesh! :grinning: :+1: :star2:

@Ganesh - follow-up…when I filter (using Custom fields), it doesn’t seem to reduce the Sprints shown (based on my filter criteria)…any idea when that’s the case?

All selected:

Filter selected:

Hello jimbok11,

Could you please elaborate your requirement ?

  1. What is requester group ? is this property of issue / sprint ?

or else, Just place “Requester group” in “Rows” as well as “Pages” then try to filter it. Hope it help. please let me know if you need any additional information’s. thanks

Steps to Place “Requester group” in rows and pages ;

  1. Drag the “Requester group” in Rows.
  2. Expand the "“Requester group” Dimension and see at bottom. you will find “Pages” Option.
  3. Click the pages Option . Now “Requester group” dimension will be placed both Rows and pages.
  4. Now try to filter your Requester group.
1 Like

Thanks @Ganesh - unfortunately, I’m not on a version of eazyBI that allows me to add a dimension on both rows & page :frowning:

In terms of the requirement, the Requester Group (and Scrum Team) is a custom field on the Issue. When I have other reports that had similar column/rows (e.g. Sprint Velocity), the filters work fine :man_shrugging:

I’m assuming because none of my column/rows have any data relating to Issues, these filters don’t work since Sprint data is not linked.

1 Like

Yes, you are correct! To make the page filter work add Sprint scope measure which have value for all sprints, for example Sprint Issues committed (https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-software-custom-fields).

Best,
Zane / support@eazyBI.com