Hi All,

Below is code for an Area Graph using the GGSALES table. It creates a miniChart for scrolling thru the months of the graph. It's currently set for 9 months and it works, but I would like the hi-lited miniChart to be positioned all the way to the right instead of being on the left. I need the data to be shown with the dates going from left to right. Can someone help create this where the miniChart defaults to the right side of the chart instead of the left.

Thanks

Here's the code ...

DEFINE FILE GGSALES
T1_TOTL/D20.2M = DOLLARS;
T1_WEST/D20.2M = IF REGION EQ 'West' THEN DOLLARS ELSE       0;
T1_OTHR/D20.2M = IF REGION EQ 'West' THEN       0 ELSE DOLLARS;
END
-*
TABLE FILE GGSALES
SUM
T1_TOTL
T1_WEST
T1_OTHR
BY DATE
ON TABLE HOLD AS HLD_T1
END
-*
DEFINE FILE HLD_T1
T1_DATE/MtDYY  = DATE;
T1_MNTH/MtY    = DATE;
T1_DOW/Wtr     = DATE;
T1_DATE/MtDYY  = DATE;
T1_DATEA/A55   = FPRINT(T1_DOW, 'Wtr', 'A9') || (', ' | FPRINT(T1_DATE, 'MtrDYY', 'A20'));
T1_TOTLA/A55   = FPRINT(T1_TOTL, 'D20.2M', 'A30');
T1_WESTA/A55   = FPRINT(T1_WEST, 'D20.2M', 'A30');
END
-*
GRAPH FILE HLD_T1
SUM
T1_WEST AS ''
T1_OTHR AS ''
T1_DATEA
T1_TOTLA
T1_WESTA
BY T1_MNTH
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH LINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, CHART-SERIES-LAYOUT=stacked,$
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=tooltip, $
TYPE=DATA, COLUMN=N5, BUCKET=tooltip, $
TYPE=DATA, COLUMN=N6, BUCKET=tooltip, $
*GRAPH_SCRIPT
setSeriesType(0,3);
setSeriesType(1,3);
setMarkerSizeDefault(50);
setMarkerShape(getSeries(0),2);
setMarkerShape(getSeries(1),2);
*GRAPH_JS
legend: {visible: false, position: 'bottom'},
xaxis: {
 scroll: {
   style: 'miniChart',
   groups: {maxCount: 9},
   miniChartProperties: {
     height:40,
     dataSelection:{selectionRect: {fill: 'rgba(112, 128, 144, 0.45)'}}
   }
 }
},
yaxis: {
 swapChartSide: true,
 labels: {visible: true, font: 'bold 8pt Sans-Serif'},
 majorGrid: {visible:true, lineStyle: {width: 1,color: 'black'}}
},
*END
*GRAPH_JS_FINAL
xaxis: {
 title: {visible: false},
},
series: [
	{series: 0,
        color: '#2e8b57',
		tooltip: '{{tooltip1}}<br><span style="color:#6495ed">Total Reported Sales:</span> [b]{{tooltip2}}[/b]<br><span style="color:#2e8b57">West Region Sales:</span> [b]{{tooltip3}}[/b]'
	},
	{series: 1,
        color: '#6495ed',
		tooltip: '{{tooltip1}}<br><span style="color:#6495ed">Total Reported Sales:</span> [b]{{tooltip2}}[/b]<br><span style="color:#2e8b57">West Region Sales:</span> [b]{{tooltip3}}[/b]'
	},
]
*END
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

Hi,
I think your expected result can be achieved by this way also.
Changing the Y axis & adding highest in sort field.

If you want to Just change Position of chart axis then in Yaxis swapChartSide = false

To change the dates : BY Highest T1_MNTH…

This message has been edited. Last edited by: Balakrishnan Palanisamy,

Hi,

Thanks for the input, but my user wants the months to run low to high (left to right) and the "swapChartSide: true," is just being used to put the y-axis body line and labels on the right side of the chart instead of the left.

I like the way the chart looks, I would just like the hi-lited minichart to be positioned to the right(highest) group of months.

There's a setting for the number of groups for the miniChart but I can't find a setting for the positioning of the hi-lited area.

jfr99

I suggest you open a case with techsupport and see if they can provide you what you need.