There are probable half a dozen ways to do it, under different circumstances. Each technique may have its own advantages.

Here is my favorite technique, which is

1) independent of date dimension. 

2) can be used from a secondary data source.

3) applicable in labels, references and annotations.

It has served me well in a number of designs. Just want to share the techniques here with you.

Here are the main steps for getting them.

Last Date

1.Create Top 1 set in Date dimension. Name the set as Last Date.

One may get the last date using Level of Details instead of Set. But then you have to be very careful of date filters.

2.To get the Last Order Date (as a Date type):

Last Value

To get the Last Value:

Note that this is at the row level or record level.

[Click here to find all my Sankey Chart series]

Quite a few people visited my post on creating 3-stage Sankey chart by cascading 2 Sankey charts. It's a scalable approach which can lead to N-stage Sankey chart using the same building block repetitively.

It seems 3-stage Sankey chart is a popular one. I think it's worthwhile to create a monolithic template like the minimal Sankey template. It takes only a few simple steps in a few minutes to quickly create a 3-stage Sankey chart.
26
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.