reg: data mapping in iChart display template

[Former Member]

hi all,

there are diff column options when one tries to map the data for iChart like value column, label columns, description columns etc.. can anybody explain me these in detail apart from the explanation thats given in help. am not really clear on this..

thanks in advance.

[Former Member · Accepted solution]

Hi Sushma,

Value Columns : Used to map the values for which you want to plot the chart (like temperature, pressure..)

Label Columns : This type of requirement you will be having for the Bar charts where for each data you may need to give description like

Example : For Batch B001 -> production cost 20,000.

For Batch B002 -> production cost 25,000.

In this case B001 and B002 are your Label columns and 20,000 and 25,000 are value columns.

Description columns : This type of requirement you will be having for the Bar charts where for each data you may need to give description like

Example : For Batch B001 -> production cost 20,000.

For Batch B002 -> production cost 25,000.

This is your data. If you want to give description like started production on 15/05/2006 and 21/08/2006 on selection of the bar. Then it will be displayed.

DatalinkColumns : This is mainly is required when you need more info from the same bar at that time you may add the plant name column as the datalink item. Then on the selection of the batch data you can get the datalink item i.e name of the plant on which it is produced can get from the datalink item. Methods for this is getChartObject().getDataLinkItem().

AxisValueColumn : This is X-axis column for your plot. Suppose you want to draw a plot for (x1,y1), (x2,y2).. in this case, x1,x2 are your label columns under column named X and y1,y1 are under column named y which is value column. In the case of tag query it will be Date time as default. These values also displayed on the X-Axis also.

And for the remaining tabs help is enough to understand...

Thanks,

Rajesh.