Trouble with iChart/Bar

[Former Member]

I have having issues creating a non-time based iChart.

Data Source

Mach1 500

Mach2 250

Mach3 400

I want to create an iChart with Mach* along the X-Axis, and Qty as the value for each Bar. I have tried the various combinations of Data Mapping, but fail to get a chart that looks like what I expect.

          500
500       **                         400
          **            250          **
250       **            **           **
          **            **           **
0         **            **           **
        Mach1         Mach2        Mach3

[Former Member]

Display Template:

<?xml version="1.0" encoding="UTF-8" ?>

<iChart ChartType="Bar" LabelColumns="OPERATION_BO" SaveDate="12/13/2007 10:22:55" ValueColumns="WORK" Version="11.5.2" />

Query Result:

<?xml version="1.0" encoding="UTF-8" ?>

<Rowsets DateCreated="2007-12-13T10:12:18" EndDate="2007-12-13T10:11:30" StartDate="2007-12-13T09:11:30" Version="11.5.2">

<Rowset>

<Columns>

<Column Description="ROUTER_BO" MaxRange="1" MinRange="0" Name="ROUTER_BO" SQLDataType="12" SourceColumn="ROUTER_BO" />

<Column Description="OPERATION_BO" MaxRange="1" MinRange="0" Name="OPERATION_BO" SQLDataType="12" SourceColumn="OPERATION_BO" />

<Column Description="STEP_ID" MaxRange="1" MinRange="0" Name="STEP_ID" SQLDataType="12" SourceColumn="STEP_ID" />

<Column Description="WORK" MaxRange="1" MinRange="0" Name="WORK" SQLDataType="2" SourceColumn="WORK" />

<Column Description="QUEUE" MaxRange="1" MinRange="0" Name="QUEUE" SQLDataType="2" SourceColumn="QUEUE" />

</Columns>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,CASTING_LOAD,#</OPERATION_BO>

<STEP_ID>010</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,PCB_PLACE,#</OPERATION_BO>

<STEP_ID>020</STEP_ID>

<WORK>1</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,COVER_PLACE,#</OPERATION_BO>

<STEP_ID>030</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,SCREW1,#</OPERATION_BO>

<STEP_ID>040</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,LABEL_PRINT,#</OPERATION_BO>

<STEP_ID>050</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,RUNIN1,#</OPERATION_BO>

<STEP_ID>060</STEP_ID>

<WORK>15</WORK>

<QUEUE>1</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,FCT1,#</OPERATION_BO>

<STEP_ID>070</STEP_ID>

<WORK>176</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,FINAL_INSP,#</OPERATION_BO>

<STEP_ID>090</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

<Row>

<ROUTER_BO>RouterBO:MSCA,FLEX1_FA_TEST,U,A</ROUTER_BO>

<OPERATION_BO>OperationBO:MSCA,FCT_REPAIR,#</OPERATION_BO>

<STEP_ID>580</STEP_ID>

<WORK>0</WORK>

<QUEUE>0</QUEUE>

</Row>

</Rowset>

</Rowsets>

[salvatore_castro]

Paul,

I would change the length of the OPERATION_BO string to be shorter and to something not so repetitive. This can be easily done via BLS...in the mean time I had to increase the label depth in order to fit everything on the chart but here's the XML to have it how you wanted it...I think...

<?xml version="1.0" encoding="utf-8"?>
<iChart AxisLabelColumns="OPERATION_BO" AxisValueColumn="OPERATION_BO" ChartType="Bar" GlobalAutoScale="true" GlobalServerScaling="false" IncludeValueInLabel="true" LabelColumns="OPERATION_BO" SaveDate="12/13/2007 16:02:46" ShowMouseTracking="true" ShowMouseTrackingBackground="false" ShowMouseTrackingDatalinkValue="false" ShowTagDescription="false" ShowTimeControl="false" Title="Machine Work" TitleFontStyle="1" ValueColumns="WORK" Version="11.5.3" XAxisLabelDepth="5" XAxisThreeD="false" ZeroBasedScale="true" />

Sam

[salvatore_castro]

Paul,

On a side note you should upgrade your xMII version to 11.5.3

Sam

[salvatore_castro]

Paul,

Post the XML of your Display template and the xml data this way we can see what the data structure looks like.

Essentially the value & label columns should be Mach1,Mach2,Mach3

Sam