AnsweredAssumed Answered

How to plot bubble chart in pentaho cde ?

Question asked by Voljinlvlan V on Aug 27, 2018
Latest reply on Aug 30, 2018 by Duarte Leao

Hi guy, I want to present my data in bubble chart style but i not see component bubble chart. and i tried to use heat grid and change shape -> circle but the result look like this

 

this is i tried to use metric Dot Chart but it split chart per dept. that i don't want

 

but the result that i want need to be like this (*** each circle is dept. & size depend on value)

 

My data source look like this

 

dept_id | dept_title | value_for_axis_x | value_for_axis_y

--------------------------------------------

2323 | sport dept. | 23.34 | 111.34
--------------------------------------------

2333 | cinema dept. | 13.34 | 101.34

--------------------------------------------

2323 | food dept. | 15.34 | 84.34
--------------------------------------------

2333 | travel dept. | 19.34 | 41.34

 

Please help thank you so much

Outcomes