R visualisation help

classic Classic list List threaded Threaded
1 message Options
nde
Reply | Threaded
Open this post in threaded view
|

R visualisation help

nde
Hey,

I've recently come into contact with the R Language via Power BI, I currently have somewhat of a problem with getting a certain matrix visualized.

I have the following table in my Power BI. I want to create an R Visual out of this.
"Image First Table"
 
So i proceded to install all the correct R installations and packages, i produced some R shaping to the table :
> str(dataset)
'data.frame': 17 obs. of 3 variables:
$ Throughput : int 611 1191 104 148 765 4215 57098 14180 26631 14813 ...
$ Label : Factor w/ 7 levels "Assess reimbursement",..: 1 1 2 3 3 4 4 4 4 4 ...
$ ThroughputAgegroup: Factor w/ 6 levels "0-14 Dagen","1-3 Maanden",..: 2 4 4 2 4 1 2 3 4 5 ...
> test <- cast(dataset, Label ~ ThroughputAgegroup, mean, value = 'Throughput')
> test
To get the following table:
"Image Second Table"
 
Now I want to visualize this, when i try plotting this using:
corrplot(test, method = "circle", tl.cex=0.6, tl.srt = 45, tl.col = "black", type= "upper", order="hclust")
to get a nice visualisation i'm prompted with the following error:
Error in matrix(unlist(value, recursive = FALSE, use.names = FALSE), nrow = nr, :
length of 'dimnames' [2] not equal to array extent
In addition: Warning message:
In Ops.factor(left, right) : ‘<’ not meaningful for factors
 
Is there any way to visualize this? So that for each match in the matrix a Cirlce with a shape is created? NaN values can be blank.
 
Tyvm in advance