iChart Group Bar - Group By

[Former Member]

I have data coming back in the format of Plant, MetricDescription, Value, Month --- there are 3 rows for each Site (trying to show past 3 months).

Currently the Group Bar chart is grouping by my Label Column which is Month and MetricDescription. I dont want this, I want it to group by Site( which is my X Axis description columns) so the three bars are together.

How can I get it to group by Site (or as used in my iChart the Description Columns) instead of the Label Columns?

[jcgood25]

Brian,

It sounds like you may be confusing AxisLabelColumns with LabelColumns.

The iChart naturally groups by the Label Columns, it will create pseudo pens for the unique combinations found in the dataset (be careful because the data needs to be square and contain data for each bar or stacked bar or the values will 'slide' to the left).

Have you tried:

ValueColumns=Value

LabelColumns=Plant,Month

If this doesn't help, just past a sample xml doc from your query into the forum for more clarification.

Regards,

Jeremy Good

[Former Member]

I think I worded my first post wrong.....

I am basically doing a "De-Stacked" stacked bar chart. I tried a regular bar chart, and that works fine except for one thing - on the X Axis it shows each site name 3 times -

---

is there a way for me to show that site name just once?

[jcgood25]

Can you post sample xml query results here in Rowsets/Rowset/Row format (cleaned up numbers and strings are fine, I just want to see the 'shape' of the dataset)?

Regards,

Jeremy Good

[Former Member]

Sure, here is a quick mock up..... again, I want three bars for each Site -- CM, PM, and TwoMonthsPrior

<?xml version="1.0" encoding="UTF-8" ?>

<Rowsets DateCreated="2007-07-03T08:38:23" EndDate="2007-07-03T08:38:22" StartDate="2007-07-03T07:38:22" Version="11.5.3">

<Rowset>

<Columns>

<Column Description="SITESHORTDS" MaxRange="1" MinRange="0" Name="SITESHORTDS" SQLDataType="12" SourceColumn="SITESHORTDS" />

<Column Description="METRICDS" MaxRange="1" MinRange="0" Name="METRICDS" SQLDataType="12" SourceColumn="METRICDS" />

<Column Description="MANUALVALUE" MaxRange="1" MinRange="0" Name="MANUALVALUE" SQLDataType="2" SourceColumn="MANUALVALUE" />

<Column Description="MONTH" MaxRange="1" MinRange="0" Name="MONTH" SQLDataType="12" SourceColumn="MONTH" />

</Columns>

<Row>

<SITESHORTDS>A</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>5</MANUALVALUE>

<MONTH>Two Months Prior</MONTH>

</Row>

<Row>

<SITESHORTDS>A</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>3</MANUALVALUE>

<MONTH>Previous Month</MONTH>

</Row>

<Row>

<SITESHORTDS>A</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>2</MANUALVALUE>

<MONTH>Current Month</MONTH>

</Row>

<Row>

<SITESHORTDS>B</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>10</MANUALVALUE>

<MONTH>Two Months Prior</MONTH>

</Row>

<Row>

<SITESHORTDS>B</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>5</MANUALVALUE>

<MONTH>Previous Month</MONTH>

</Row>

<Row>

<SITESHORTDS>B</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>18</MANUALVALUE>

<MONTH>Current Month</MONTH>

</Row>

<Row>

<SITESHORTDS>C</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>1</MANUALVALUE>

<MONTH>Two Months Prior</MONTH>

</Row>

<Row>

<SITESHORTDS>C</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>0</MANUALVALUE>

<MONTH>Current Month</MONTH>

</Row>

<Row>

<SITESHORTDS>C</SITESHORTDS>

<METRICDS>1.2.11</METRICDS>

<MANUALVALUE>1</MANUALVALUE>

<MONTH>Previous Month</MONTH>

</Row>

</Rowset>

</Rowsets>

[jcgood25]

Brian,

With that dataset I would set up your display template with these basic settings (not including the cosmetic settings of course):

ChartType = GroupBar

ShowMouseTrackingDatalinkValue = true

ShowMouseTrackingXValue = false

ShowTagDescription = false

ValueColumns = MANUALVALUE

LabelColumns = SITESHORTDS

DataLinkColumns = MONTH

These settings should create 3 pens, with 3 bars in the associated color for your grouped for the rolling month results. The mouse tracking will allow the bars to show their YAxis number, but not try to squeeze the strings for the month label into the xaxis, but as a user hovers over the bar with the mouse the strings for CM, PV, etc. will show up on the top left corner of the chart.

Regards,

Jeremy Good