Gant type run chart using chart applets

[Former Member]

I've been playing around with the event horizon chart a bit, but can't get it to do what I want here. Basically this is a line status chart. The x-axis it time, and the chart shows line stats over time. For example if running, we get a status of 0, then I want that time to be green, hold status is 1, and i want a yellow, fault is a status of 2 and I want red and. Basically this an informational chart showing line events showing up times in a graphical sense.

Here is my concept in graphical form.

http://s246.photobucket.com/albums/gg99/daholtke/?action=view&current=EventChartcopy.jpg

[salvatore_castro]

Doug,

My guess is that the chart you want is like the one in the picture and the one you are getting has whitespace due to not enough datapoints or the one that is filled in requires too many datapoints and is slow.

There's no real way around this unless you are performing a tag query then you can kind of get this to work. In the display template check use screen resolution and set the Tag Query to be of type History. This will give you the least amount of necessary data points for the chart size.

It's a big work around but there's no other option that I can think of.

Sam

[jcgood25]

The picture of your applet looks fine to me, what's the problem? Looks like a tag query results from a historian in History mode where the 'events' are interpolated. When the iChart has the UseScreenResolution=true it sets the query RowCount to the number of pixels in the chart area, so the historian conveniently (with a Resolution=0 of course) interpolates a single pixel vertical line and fills in all of the space according to your pen colors.

What do you want the EventHorizon to do?

[Former Member]

I should have clarified, the picture I posted is a photoshop mock up of what I want. The dataset I is like this. I'm using mock up data for now. The orginal data will be RSSQL or perhaps a standard SQL table. Right now that part is up in the air.

Example Dataset

Timestamp Value

1/24/2007 11:20:20 0

1/24/2007 11:30:12 2

1/24/2007 12:41:34 0

1/24/2007 12:51:00 1

1/24/2007 13:11:18 0

Right now the Event Horizon chart gives me a series of thin lines at each record with different colors for record, even when the value is the same.

[salvatore_castro]

Doug,

You might be able to pull off something fancy with the TimeInterpolator action block where you merge the actual data with a Tag History Query and strip out the Tag column and then return the new "interpolated" dataset back to the chart. Basically use the interpolator to swap your data with the tag data and keep the date fields. This will in turn up your row count to fill in the Event Horizon chart, this will be slower due to the number of datapoints required.

Sam

[Former Member]

The "interpolation" approach would "work", but it would be terribly inefficient. If there was such a thing as a horizontal stacked bar chart, that would probably be the easiest way.

Best off to use the Gantt chart XSL transforms and/or BLS transactions that I did for downtime display. Originally it was done as an XML->HTML XSL transform, but I rewrote it at some point in BLS. Not a lot of people know that you can use BLS to dynamically generate HTML (and, using some magic in IRPT pages and the <SERVLET> tag, you can stream BLS content "mid-page"). You end up using some absolute positioning attributes to place and size a series of 1x1 images in whatever color(s) you need.

Works great.

[Former Member]

Doug,

I've done this type of thing in the past with a couple of customers. Use the Area Chart and set the Y-axis range to 0 to 1.

Then, for each type of record (or color), set the value to 0 or 1. For a given time stamp, only one of your pens should be set to 1.

Whatever pen is 1, that is the pen color that will fill in the block until the next datestamp where another pen is 1.

You'll probably need to use BLS to get the records to be only 0 or 1. It works, and it is actually quite quick.