How to create an IChart

[Former Member]

Hi experts,

I have a problem. I need to create a bar IChart of a simple SQL Query. Query returns for example:

Status Number_Of_Boards_In_DB

A 1245

S 7888

L 10

(There are always these 3 states, only count changes)

I already created an IChart and selected the query template and assigned the Number_Of_Boards_In_DB to the value column.

So, my question is, how do I get the Status (A, S, L) in the x-axis and the values (properly scaled) in the y-axis. Tried already various combinations but nothing returned the desired result.

I'm using MII 12.0.4.

Thanks for your answers.

Best Regards,

Robert

[jcgood25 · Accepted solution]

For Y-Axis scaling you will probably want to disable Global Server Scaling and use Global Auto Scaling.

[Former Member · Accepted solution]

Thanks for your input. Now the scaling works as I want. I probably marked or unmarked the wrong checkboxes, now everything is fine.

[jcgood25]

Robert,

ValueColumns = Number_Of_Boards_In_DB

LabelColumns = Status

By using Status as the label columns you will have 3 pens in the legend (different colors), and by default in a bar chart the actual bar's value will show up on the XAxis.

If you want to see only the 'Status' pen in the legend then you obviously don't want to use the LabelColumns like I mentioned, but have you tried mapping Status to AxisValueColumn?

Regards,

Jeremy