Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Correlation Plot visual - issue

Hi team,

I’m trying to visualize in a Correlation plot visual, the correlation between the Values of two different tasks. Here is my data:

Date

DateKey

Task

Value

01.01.2022  

20220101  

AA1  

35   

02.01.2022

20220102

AA1

40

03.01.2022

20220103

AA1

50

04.01.2022

20220104

AA1

100

05.01.2022

20220105

AA1

20

06.01.2022

20220106

AA1

30

07.01.2022

20220107

AA1

90

08.01.2022

20220108

AA1

17

09.01.2022

20220109

AA1

19

10.01.2022

20220110

AA1

21

01.01.2022

20220101

BB2

60

02.01.2022

20220102

BB2

54

03.01.2022

20220103

BB2

23

04.01.2022

20220104

BB2

90

05.01.2022

20220105

BB2

75

06.01.2022

20220106

BB2

12

07.01.2022

20220107

BB2

36

08.01.2022

20220108

BB2

78

09.01.2022

20220109

BB2

77

10.01.2022

20220110

BB2

29

01.01.2022

20220101

CC3

130

02.01.2022

20220102

CC3

140

03.01.2022

20220103

CC3

36

04.01.2022

20220104

CC3

76

05.01.2022

20220105

CC3

44

06.01.2022

20220106

CC3

35

07.01.2022

20220107

CC3

29

08.01.2022

20220108

CC3

57

09.01.2022

20220109

CC3

28

10.01.2022

20220110

CC3

95

 

I have installed R and the ‘corrplot’ package, but when I try to put “Task” field and Value, no data populates in the visual. The only way to see data in the visual is to put two value fields, but no task (text).

The end result I’m looking for is this:

 

 

 

 

 

 

 

 


*The first left bubble should be the correlation between sum of the values of AA1 and sum of the values of AA1. The second bubble, row one, is the correlation between sum of the values of of BB2 and sum of the values of AA1.

Do you have an idea is it possible to present my data in this look with a correlation plot visual or what transformation should I make?

Thank you.

1 Reply