on 07-02-2007 4:52 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
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
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.