how to map data on a iChart GroupBar?

[Former Member]

Hello, I have a problem understanding the iChart GroupBar display template.

For example, a SQL query return three columns,

Category, x, y

I want to plot (x-value on x-axis, y-value on y-axis. And I have to group the (x, y) points according to the category they belong to.

So the chart will look like

two bars in category 1 in one color, 3 bars in category 2 in 2nd color, and so on.

I don't know how to map three columns on

Value column

Label column

Description column

Data link column

Axis Label column

Axis Value column

I almost try every possibilities, but it confused me again and again...

Your help is appreciated!!!

[Former Member · Accepted solution]

Try:

Y in Value Column

X in Axis Label Column

Category in Label Column

if that doesn't work please provide a few lines of sample data.

Joe

[Former Member · Accepted solution]

Hi Joe, it works! Thanks a lot!