In brief, to get a set of line charts for the top N destination airport (ADES) from a given departure airport (ADEP) you need to do the following:
- Set up your line chart, with Month in the column shelf say, and one or measures in the row shelf.
- Filter by departure airport.
- Select both ADEP and ADES (ctrl-click) and create combined dimension.
- Drag this combo into the colour field in the measures pane, and sort by descending sum(pax) (or whatever).
- Create calculated field which is just Index() - I named it Rank (which is more or less what it is).
- Set it as discrete.
- Drag to the filter.
- Right-click and select compute using the combo field.
- Choose the filter values (eg 1-5).
Obvious! (I hope I recalled all those steps correctly). Here's the final dashboard - with test data only.
[For links to dashboard - production and development versions - see top of page.]
No comments:
Post a Comment