Skip to main content

Hi All,

 

I am trying to create a Sankey Chart. My dimension on the left side is 'ID' (2 numbers in this example) and right side is 'field' (4 in number in this example).

 

One of my ID's flow to all the four 'fields' and other flows into three fields. 

 

I have used the following as calculation -

 

Rank1 - RUNNING_SUM(COUNTD([CASEID]))/TOTAL(COUNTD([CASEID]))

Rank2 - RUNNING_SUM(COUNTD([CASEID]))/TOTAL(COUNTD([CASEID]))

To Pad. - if [RowType]=='Real' then 1 else 49 end.  ( so I duplicated the table one named 'Real' and another named 'Dummy' )

t - (index()-25)/4

Curve - [Rank1]+(([Rank2] - [Rank1])*[Sigmoid])

Sigmoid - 1/(1+EXP(1)^-[t])

Padded - created a bin from Pad with Size as 1.

 

I want to know why are the lines not emerging from one point for each case ID and why the lines from both ID's that move to the same field name not merge on that filed.

 

Any advise would be appreciated.

 

Thanking you all

 

Regards,

RS

2 answers
0/9000