2
Reply

project

Ask a question
Hello Team,
 
As i have to develop a list on issue.
so on basis of ticket Issue i have to plot a graph(open,close,in-progress)
the list contain ticket status,ticket priority and ticket count.
when i developed that legend gets on going when ever i add any item in that list.
how to restrict it.
i have to make a bar and a pie chart 
i uses high-charts,jquery and content editor with folling program:
 
<script type="text/javascript" src="http://dskptmof06:8080/SiteAssets/jquery.js"></script>
<script type="text/javascript" src="http://dskptmof06:8080/SiteAssets/highcharts.js"></script>
<script type="text/javascript">
var splistitems;
var seriesarray = new Array();
ExecuteOrDelayUntilScriptLoaded(GetChartData, "sp.js");
function GetChartData() {
seriesarray = [];
var currentcontext = new SP.ClientContext.get_current();
var splist = currentcontext.get_web().get_lists().getByTitle('ScmsTicket');
var splistquery = new SP.CamlQuery();
splistitems = splist.getItems(splistquery);
currentcontext.load(splistitems);
currentcontext.executeQueryAsync(Function.createDelegate(this, GetChartDataSuccess), Function.createDelegate(this, GetChartDataFail));
}
function GetChartDataSuccess(sender, args) {
var splistitemcount = splistitems.get_count();
if (splistitemcount != 0) {
var splistitemenumerator = splistitems.getEnumerator();
while (splistitemenumerator.moveNext()) {
var currentlistitem = splistitemenumerator.get_current();
var itemname = currentlistitem.get_item("Title");
var itemTicket_Status = currentlistitem.get_item("Ticket_Status");
var itemTicket_Priority = currentlistitem.get_item("Ticket_Priority");
var itemTicket_count = currentlistitem.get_item("Ticket_count");
var seriesitem = {
name: itemTicket_Status,
data: [itemTicket_count]
};
seriesarray.push(seriesitem);
}
DrawChart();
}
}
function GetChartDataFail(sender, args) {
alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}
function DrawChart() {
ScmsTicket = new Highcharts.Chart({
chart: {
renderTo: 'chart-container',
type: 'bar'
},
title: {
text: 'ScmsTicket'
},
xAxis: {
categories: ['Ticket_Status']
},
yAxis: {
min: 0,
title: {
text: 'ScmsTicket'
},
stackLabels: {
enabled: false,
style: {
fontWeight: 'bold',
color: 'gray'
}
}
},
legend: {
align: 'right',
x: -70,
verticalAlign: 'top',
y: 20,
floating: true,
backgroundColor: 'white',
borderColor: '#CCC',
borderWidth: 1,
shadow: false
},
tooltip: {
formatter: function() {
return '<b>'+ this.x +'</b><br/>'+
this.series.name +': '+ this.y +'<br/>'+
'Total: '+ this.point.stackTotal;
}
},
plotOptions: {
column: {
stacking: 'normal',
dataLabels:{
enabled: true,
color: 'white',
style: {
textShadow: '0 0 3px black, 0 0 3px black'
}
}
}
},
series: seriesarray
});
}
</script>
<div id="chart-container">ScmsTicket.</div>
plz help me with appropriate program 
 
 

Answers (2)