cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cheriemilk Frequent Visitor
Frequent Visitor

[need help] Error occurs when creating Sankey diagram by R script

Hi Team,

I did data transform by creating a new table with DAX, and the format of new table is sankey format: Source, Target, Occurs(Please refer to below table1)

Table1:

sankeytable.jpg

Then I trying to create sankey diagram with R visulization, here is the script:

 

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
 
dataset <- data.frame(Source, Target, Occurs)
dataset <- unique(dataset)
library(networkD3)
dataset$Source = as.character(dataset$Source)
dataset$Target = as.character(dataset$Target)
Sankeylinks<-dataset
Sankeynodes<-data.frame(name=unique(c(Sankeylinks$Source,Sankeylinks$Target)))
Sankeynodes$index<-0: (nrow(Sankeynodes) - 1)
Sankeylinks<-merge(Sankeylinks,Sankeynodes,by.x="Source",by.y="name")
Sankeylinks<-merge(Sankeylinks,Sankeynodes,by.x="Target",by.y="name")
Sankeydata<-Sankeylinks[,c(4,5,3)];
names(Sankeydata)<-c("Source","Target","Occurs")
Sankeyname<-Sankeynodes[,1,drop=FALSE]
# draw sankey network
sankeyNetwork(Links=Sankeydata,Nodes=Sankeyname,Source="Source",Target="Target",Value="Occurs",NodeId="name",fontsize=8,nodeWidth=20)
But there is error occured.
error.jpg
 
what is the issue with my script?
1 REPLY 1
v-evelk Senior Member
Senior Member

Re: [need help] Error occurs when creating Sankey diagram by R script

Hi,

 

The error on your picture says that field name is unavailable.

Please check that you correctly typed all your fileds names.

Also, pay attention please that using fileds must be added to "Values" bucket to be available in a script regarding this article.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 282 members 2,884 guests
Please welcome our newest community members: