Line chart x-axis label overloaded with labels

[Former Member]

Hi,

I have a Line chart filled by a large resultset (hundreds of rows). Each row contains a decimal value and a timestamp. The interval between timestamps is short so it is impossible to plot every single date/time in the x-axis label because there is no space.

I would like to hide the the x-axis label for most rows and plot this label for each x rows. Something like this:

  18/12/2009 09:00            18/12/2009 10:00           18/12/2009 11:00            18/12/2009 12:00
        |---------------------------|---------------------------|---------------------------|

In the previous x-axis example there are many timestamps between 18/12/2009 09:00 and 18/12/2009 10:00 but they are not plotted in the chart. It is possible to do something like this in MII charts?

Thank you,

--

Wilson Freitas

Vetta Technologies

[jamie_cawley · Accepted solution]

Try messing around with the Ticks Per Label property in the Y-Axis template category.

Jamie

[Former Member · Accepted solution]

Dear Jamie,

Changing the Ticks per Label parameter works as expected for Y-axis. It changes the number of displayed labels in Y-axis.

But when I change the same parameter for X-axis looks like it has no effect because I still keep getting the chart with hundreds of labels.

Thank you.

[Former Member · Accepted solution]

Wilson,

have you tried to set the "Number of Major Ticks" to the number of labels you want to see? If not, try this and set "Number of Minor Ticks " = 0 and "Ticks per label" = 1. This helped me out with a similar problem havin too many labels.

Michael

[Former Member · Accepted solution]

Hi,

I think Michael is right about the Ticks per label parameter. Looks like it is not working for me because the chart data binding is not behaving as expected.

The chart rowset is composed by two fields: decimal and date time. The date time field is already converted to string. The rowset comes from a BLS transaction.

I think this forum has no support for file upload so I will add links to the xMII workbench screenshots so you guys can see my chart/query configuration.

This is the XACUTE Query used by the chart: http://www.vetta-group.com:8080/imgs/xacute_config.PNG

This is the Line Chart configuration:

- Chart area:http://www.vetta-group.com:8080/imgs/chart_area.PNG

- Data mapping: http://www.vetta-group.com:8080/imgs/data_mapping.PNG

- X-axis: http://www.vetta-group.com:8080/imgs/xaxis.PNG

- Y-axis: http://www.vetta-group.com:8080/imgs/yaxis.PNG

- Server scaling:http://www.vetta-group.com:8080/imgs/server_scaling.PNG

- Data series:http://www.vetta-group.com:8080/imgs/data_series.PNG

The chart row set is:

<?xml version="1.0" encoding="UTF-8" ?>
<Rowsets DateCreated="2010-02-02T20:50:08" EndDate="2010-02-02T20:50:07"
	StartDate="2010-02-02T19:50:07" Version="12.0.8 Build(24)">
	<Rowset>
		<Columns>
			<Column Description="" MaxRange="1" MinRange="0" Name="TAG_TIMESTAMP"
				SQLDataType="1" SourceColumn="TAG_TIMESTAMP" />
			<Column Description="" MaxRange="1" MinRange="0" Name="TAG_VALUE"
				SQLDataType="8" SourceColumn="TAG_VALUE" />
		</Columns>
		<Row>
			<TAG_TIMESTAMP>01/12/2009 12:00:00</TAG_TIMESTAMP>
			<TAG_VALUE>80.723414730584</TAG_VALUE>
		</Row>
		<Row>
			<TAG_TIMESTAMP>01/12/2009 12:23:59</TAG_TIMESTAMP>
			<TAG_VALUE>87.33149769706</TAG_VALUE>
		</Row>
		<Row>
			<TAG_TIMESTAMP>02/12/2009 12:47:59</TAG_TIMESTAMP>
			<TAG_VALUE>86.966843701221</TAG_VALUE>
		</Row>
		<Row>
			<TAG_TIMESTAMP>02/12/2009 01:11:59</TAG_TIMESTAMP>
			<TAG_VALUE>83.989991258174</TAG_VALUE>
		</Row>
		...
	</Rowset>
</Rowsets>

When I run the chart I get this result: http://www.vetta-group.com:8080/imgs/chart1.PNG

As you can see the chart has no X-Axis labels ans I need to add the date/time to the X-axis. If I add the field to "X-Axis label columns" the field values are ploted but the parameter "Ticks per label" is ignored and hundreds of labels are ploted together and is impossible to read them. I think the "Ticks per label" parameter only works for fields added to Labels columns (in data mapping). The problem I am facing is: when I add the date field (http://www.vetta-group.com:8080/imgs/data_mapping2.PNG) to Label columns I get an empty chart like this: http://www.vetta-group.com:8080/imgs/chart2.PNG

What am I doing wrong?

Thank you

[Former Member · Accepted solution]

Sorry about the last message. I don't know why is unformatted. The forum software simply ignored all formatting.

[jcgood25 · Accepted solution]

It would appear that you are trying to render a time based line trend, similar to a History query from simulator, where the ticks per label and the datetime fields are displayed on the x-axis by default (you'll also notice that the time is also word wrapped underneath the date).

You'll need to make your query template and underlying trx to be date sensitive, and you'll need two date input fields in your trx that you map to the start date and end date mapped input fields (instead of Param.2 and Param.3 in one of your images).

You'll then be able to use the date tab with time periods, etc. to send these into your trx (the conversion from whatever your query's DateFormat is to the xml date format for the two mapped fields is automatically done).

In your TRX I assume you're making some sort of query action, and you can simply link the TRX date inputs to the special QueryStartDate / QueryEndDate links (notice the icon matches). The query will then use these dates (and auto convert the format) in the StartDate / EndDate fields.

With a time based / date sensitive Xacute Query template that returns DateTime / Value looking result sets your iChart data mapping should be very simple as this will more or less emulate the behavior of a Tag Query for your trend chart.

[Former Member · Accepted solution]

Jeremy,

Your solution saved my day.

Than you very much!

[Former Member]

I forgot to specify the MII release.

It is 12.0.