Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Chart with Tag Query

Similarly to this post SPC Chart - Multi Line Display

I have a Tag Query pulling data for the past X number of days and then display it in a chart.

I want to add to 2 fixed lines into this chart, similar to an SPC Chart -


basically showing how close/off that tag is from these lines.

The only thing I can think off is changing my Tag Query to a SQL query and adding these two fixed values in there ---but I would rather not do that. I would prefer to keep the Tag Query (reusability purposes)

Come on applet lovers, show me the way and tell me what to do to get them in there!

Former Member
replied

Brian,

'Applet Lovers' - is that a new at Pizza Hut?

If you wrap your TagQuery in a BLS trx and create an IllumDoc that looks like:

DateTime Line1 Line2

SD 12 34

ED 12 34

Then just merge the two documents (the TagQuery and the IllumDoc) so you will have a full OutputXML from the TRX that looks like:

<Rowsets>

<Rowset/> {Tag.1}

<Rowset/> {Tag.n}

<Rowset/>

</Rowsets>

The iChart will then see the limit lines as if they were tagnames all along and will plot two lines from SD to ED.

If you only have a single Rowset returning from you TagQuery, then even easier would just be to add a CalculatedColumn block onto it with 2 static number columns. The chart will like this format too (a lot like a multiple tagname Simulator query).

Regards,

Jeremy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question