Generating custom chart

[Former Member]

Hi,

I am facing the following problem while generating charts.

I have a tag query returning current values of two tags - T1 and T2.

If I am plotting the chart at 12.20,

The X-axis points would be 11.30, 12.00, 12.30, 1.00.

T2 should be shown as bar in the current 30 minutes range, i.e. 12.00 to 12.30

T1 should be plotted as a straight line for the whole duration.

I have used a Custom chart setting the pen type to Line for T1 and pen type as Bar for T2. If I set the value at 12.00 to T2 and for all all other X-axis points to 0, I get a bar at 12.00. How can I set the bar in the range from 12 to 12.30?

If I iterate through all the points in the range 12 to 12.30 and set it to T2, then the X-axis range goes haywire!

Can anybody help me out? Thanks.

Edited by: Amrita Nandagopal on Jan 31, 2008 9:11 AM

[salvatore_castro]

Post an XML sample of your data and the XML for your display chart....

Sam

[Former Member]

Hi,

XML sample attached....

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

- <Rowsets DateCreated="2008-02-01T14:56:11" EndDate="2008-02-01T14:56:11" StartDate="2008-02-01T13:56:11" Version="11.5.0">

- <Rowset>

- <Columns>

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

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

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

</Columns>

- <Row>

<MaxValue>195.054195418761</MaxValue>

<AvgValue>0</AvgValue>

<Time>2008-02-01T14:00:11</Time>

</Row>

- <Row>

<MaxValue>195.054195418761</MaxValue>

<AvgValue>2.41</AvgValue>

<Time>2008-02-01T14:30:11</Time>

</Row>

- <Row>

<MaxValue>195.054195418761</MaxValue>

<AvgValue>0</AvgValue>

<Time>2008-02-01T15:00:11</Time>

</Row>

- <Row>

<MaxValue>195.054195418761</MaxValue>

<AvgValue>0</AvgValue>

<Time>2008-02-01T15:30:11</Time>

</Row>

</Rowset>

</Rowsets>

I am creating this xml dynamically thro a txn at the time the chart is generated. The above xml was created at 2008-02-01T14:56:11.

AvgValue is set to 2.41 at 2008-02-01T14:30:11 and zero at other points.

Am I going wrong in creating the xml?

[Former Member]

You might want to change your "Time" column to a date/time type (SQLDataType = 93), instead of a string.

[salvatore_castro]

On a side note, you should update your system to 11.5.3....

Sam

[agentry_src]

Don't set the value to zero, when what you want is actually nullnumber.

If you were building an Illuminator Document, you would set the T2 fields to nullnumber (a BLS function) except when you have valid data. Since your X axis is tied to the datetime value, no other Bars would show up except for those positions which had data. If you set it to zero, xMII still trys to plot it as a bar.

Hope this helps,

Mike