Order columns within a grouped by row for roadmapping

Questions & Answers
1

I have created a roadmap view using the Bar Chart view in eazyBI. It is built on epics, which are grouped by team. They default to be ordered by rank it looks like, but I would like to group the epics by team, and then sort by planned start date, in order to allow me to show a more cascading, Gantt style view of the roadmap. However, when ordering the column to Ascend Planned Start Date, it reorders all the epics, which reshuffles the Team group by in the rows.

How can I order columns within a section of a row, and still retain the group by view I am after?

Pics below, thanks!

DB

It will only allow me to upload one, but I basically want:

  • Team 1: All their epics, ordered by Planned Start
  • Team 2: All their epics, ordered by Planned Start
  • etc.

Right now, I have something like:

  • Epics with no Planned Start
  • Epic with 1st Planned Start, for Team 2
  • Epic with 2nd Planned Start, for Team 1
  • Epic with 3rd Planned Start, for Team 2,
  • etc.

image
image.png2204×1390 538 KB

2

Hi,

In this case, you may want to try defining a new calculated member in “Issue” dimension (you must save it in epic hierarchy) - once you have imported “Epic Link” custom field to create the Epic hierarchy.
There you could order your epics using BASC method not to ignore other dimensions in your report.

Try this code:

Aggregate(
Order(
[Issue.Epic].[Epic].Members,
[Measures].[Planned Start],
BASC --important to order within the dimension
)
)

In recent versions it may display warning when creating such calculated member, you can skip it this time.

When new calculated member is selected, it is fine to remove (

Sorted%20epics
Sorted epics.jpg3012×1448 564 KB
by clicking on it) the header row to display just epics but no the aggregated calculated member’s

Martins / eazyBI support