cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Pie Chart - Exploding Pie

Ophir_Buchman
Sisense Team Member
Sisense Team Member

When creating a pie chart you'd sometimes want to emphasize the difference between pie slices by displaying an "exploding effect" based on the pie values.
This will be performed by teaching Sisnese a new visualization known as a "variable pie"

Apply the following widget script:

// Register a new chart type
(function(g) {
"object"===typeof module&&module.exports?module.exports=g:g(Highcharts)
})

(function(g) {
(function(f) {
var g=f.pick,t=f.each,q=f.grep,u=f.arrayMin,w=f.arrayMax,x=f.seriesType,y=f.seriesTypes.pie.prototype
x("variablepie","pie",{
minPointSize:"10%",maxPointSize:"100%",zMin:void 0,zMax:void 0,sizeBy:"area",tooltip: {
pointFormat:'<span style="color:{point.color}">\u25cf</span> {series.name}<br/>Value: {point.y}'
}
},
{
pointArrayMap:["y","z"], parallelArrays:["x","y","z"],redraw:function() {
this.center=null
y.redraw.call(this,arguments)
},
zValEval:function(a) {
return"number"!==typeof a||isNaN(a)?null:!0
},
calculateExtremes:function() {
var a=this.chart,k=this.options,e
e=this.zData
var z=Math.min(a.plotWidth,a.plotHeight)-2*(k.slicedOffset||0),h={},a=this.center||this.getCenter()
t(["minPointSize","maxPointSize"],function(a) {
var b=k[a],c=/%$/.test(b),b=parseInt(b,10)
h[a]=c?z*b/100:2*b
})
this.minPxSize=a[3]+h.minPointSize
this.maxPxSize=Math.max(Math.min(a[2],h.maxPointSize),a[3]+h.minPointSize)
e.length&&(a=g(k.zMin,u(q(e,this.zValEval))),e=g(k.zMax,w(q(e,this.zValEval))),this.getRadii(a,e,this.minPxSize,this.maxPxSize))
},
getRadii:function(a,k,e,g) {
var h=0,b,l=this.zData,c=l.length,n=[],f="radius"!==this.options.sizeBy,m=k-a
for(h;h<c;h++)
b=this.zValEval(l[h])?l[h]:a,b<=a?b=e/2:b>=k?b=g/2:(b=0<m?(b-a)/m:.5,f&&(b=Math.sqrt(b)),b=Math.ceil(e+b*(g-e))/2),n.push(b)
this.radii=n
},
translate:function(a) {
this.generatePoints()
var k=0,e=this.options,f=e.slicedOffset,h=f+(e.borderWidth||0),b,l,c,n=e.startAngle||0,r=Math.PI/180*(n-90),m=Math.PI/180*(g(e.endAngle,n+360)-90),n=m-r,q=this.points,v,t=e.dataLabels.distance,e=e.ignoreHiddenPoint,u=q.length,d,p
this.startAngleRad=r
this.endAngleRad=m
this.calculateExtremes()
a||(this.center=a=this.getCenter())
this.getX=function(b,e,d) {
var f=d.series.radii[d.index]
c=Math.asin(Math.max(Math.min((b-a[1])/(f+d.labelDistance),1),-1))
return a[0]+(e?-1:1)*Math.cos(c)*(f+d.labelDistance)
}
for(m=0;m<u;m++) {
d=q[m]
p=this.radii[m]
d.labelDistance=g(d.options.dataLabels&&d.options.dataLabels.distance,t)
this.maxLabelDistance=Math.max(this.maxLabelDistance||0,d.labelDistance)
l=r+k*n
if(!e||d.visible)
k+=d.percentage/100
b=r+k*n
d.shapeType="arc"
d.shapeArgs={x:a[0],y:a[1],r:p,innerR:a[3]/2,start:Math.round(1E3*l)/1E3,end:Math.round(1E3*b)/1E3}
c=(b+l)/2
c>1.5*Math.PI?c-=2*Math.PI:c<-Math.PI/2&&(c+=2*Math.PI)
d.slicedTranslation={translateX:Math.round(Math.cos(c)*f),translateY:Math.round(Math.sin(c)*f)}
b=Math.cos(c)*a[2]/2
v=Math.sin(c)*a[2]/2
l=Math.cos(c)*p
p*=Math.sin(c)
d.tooltipPos=[a[0]+.7*b,a[1]+.7*v]
d.half=c<-Math.PI/2||c>Math.PI/2?1:0
d.angle=c
b=Math.min(h,d.labelDistance/5)
d.labelPos=[a[0]+l+Math.cos(c)*d.labelDistance,a[1]+p+Math.sin(c)*d.labelDistance,a[0]+l+Math.cos(c)*b,a[1]+p+Math.sin(c)*b,a[0]+l,a[1]+p,0>d.labelDistance?"center":d.half?"right":"left",c]
}
}
})
})
(g)
});

 

widget.on('processresult', function(widget,ev) {
ev.result.chart.type = 'variablepie'
ev.result.series[0].innerSize = '20%' // The pie's inner "empty" space would consume 20%
ev.result.series[0].minPointSize = '20%' // The smallest pie slice (value = 0) would show as 20% of the possible slice depth
ev.result.series[0].data.forEach(function(item) {
item.y = Math.round(item.y * 100) / 100
item.z = item.y
})
ev.result.tooltip.enabled = true;
Highcharts.setOptions({
lang: {
decimalPoint: '.',
thousandsSep: ','
}
})
})
Before After
Ophir_Buchman_0-1653547136278.png Ophir_Buchman_1-1653547150927.png

3 REPLIES 3

ItsMeAlec
8 - Cloud Apps
8 - Cloud Apps

wow this is awesome! What is you wanted the smaller values to have more "explosion"?

EmoTrans
7 - Data Storage
7 - Data Storage

Hi there, how do I apply both scripts; sorry still new to scripting in Sisense. When I paste both into the script editor for the widget, the widget is blank when I reload the dashboard.

Thx Hendrik

I figured it out. Thank you! Top script in dashboard, bottom in widget. Do you have any other 'replacement' scripts for other charts/ chart types?

Love this one ๐Ÿ™‚

B RGDS

Hendrik