Below is the generator script we are using. In the related list we have trend of open incidents and trend of closed incidents. chart is getting generated.
// Get the sys_id values for the sys_report_summary table entries build by our generators
var openID = summary_sets.get("Trend of Open Incidents");
var closedID = summary_sets.get("Trend of Closed Incidents");
//var backLogID = summary_sets.get("Incident Backlog");
// Gets a utility class for dataset manipulation
var cu = new ChartUtil();
cu.setTable('incident');
cu.setColors("#FFDEAD,#7FFF00");
// Get the dataset for the Open incidents
var open = new ChartGenerator("bar");
open.setTable('incident');
open.setSummaryID(openID);
var ds = open.getDataset();
// Get the dataset for the Closed incidents and combine with the open incidents into
// a multi series dataset
var closed = new ChartGenerator("line");
closed.setTable('incident');
closed.setSummaryID(closedID);
ds = cu.mergeDatasets(ds, "Open", closed.getDataset(), "Closed");
// Get the chart for the multi series bar chart of open and closed incidents
var chart = closed.getChart(ds);
// Change the spacing
closed.setNoMargins();
answer=chart;
1.But i want to add a condition to trend of opened incidents and trend of closed incidents generator. condition being: assignment group is desktop support or help desk group.( in the trend of open incidents generator i know how to add one condition. by adding opened.setTrend('assignment_group', 'Help Desk'); but how do i add "or" condition? ).
2.Chart is getting generated but, when i click on chart i cannot see list of incidents.
3.months are overlapping like in the figure.
Out of box, i could get TREND chart only for Time related field like months/year/day etc.
plz see this and let me know.
