Waterfall Ichart Issue

[Former Member]

Hi All,

I am trying to create Waterfall iChart from MII Workbench for below sample data.

Label	Values
Totaltime	100
PMs	-10
Scheduletime	90
Manc	-20
Changeover	-10
Effectivevalues	60

I have following queries:

1. Do we need to specify any start value and end value.

2. How to specify the Positive and Negative values. I mean whether it should be separate columns from query output.

3. How to map the data series color and values accordingly to Positive and Negative values.

Since am New to the charts in MII, am  finding very hard about mapping the values. Pls guide me step by step approach for this or any link would be of great help.

Your help on this will be highly appreciated.

Regards,

Praveen.

[jcgood25]

It's been a long time since I did some waterfall testing, but as you can see from the vintage 10.0 version xml file I found buried in my hard drive from 2003, your dataset should be perfectly OK:

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

<Rowsets DateCreated="2003-07-17T11:07:57" EndDate="2003-07-17T11:07:57" StartDate="2003-07-17T10:07:57" Version="10.0.0">

<Rowset>

  <Columns>

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

   <Column Description="Value" MaxRange="100" MinRange="0" Name="Value" SQLDataType="8" SourceColumn="Value"/>

  </Columns>

  <Row>

   <Label>A</Label>

   <Value>90</Value>

  </Row>

  <Row>

   <Label>B</Label>

   <Value>-10</Value>

  </Row>

  <Row>

   <Label>C</Label>

   <Value>14</Value>

  </Row>

  <Row>

   <Label>D</Label>

   <Value>-12</Value>

  </Row>

  <Row>

   <Label>E</Label>

   <Value>5</Value>

  </Row>

</Rowset>

</Rowsets>

From the corresponding Display Template I found, here were some of the relevant iChart settings:

AxisLabelColumns="Label" ChartType="Waterfall" CustomLabels="-,-,-,-,-,-,Total" GlobalServerScaling="false" UseGlobalRanges="true" ValueColumns="Value"  ZeroBasedCenterline="true"

Good luck - perhaps consider sharing a picture of your finished chart