cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Bar Chart

Former Member
0 Kudos

Hi,

I am creating a bar chart with a column of integer on y-axis and time on x-axis.

The height of the bar is not correct. Say for example if the value is 3 on y-axis it is mapping the bar above the mark 3 on y-axis.

Can some one help me in this regard.

Thanks.

Srinivasa.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Your scaling rules are not configured properly. On the Pen Details page of the display template, either enable autoscaling, or specify a min/max range for the y-axis. Be sure to turn off "Global Server Scaling", which is the default. This works only for "Tag" queries/data sources.

- Rick

Former Member
0 Kudos

Rick,

I tried changing these options in many combinations. But no luck.

I am trying to provide a screen shot but I couldn't find any server for these free service. Anyway I will explain in little detail.

Even though my y-axis column is of type integer it is showing each integer three times on y-axis. Each bar is ploted upto middle integer. Is ther any way to change count increment for each major tick.

Thanks,

Srinivas

jcgood25
Active Contributor
0 Kudos

Srinivas,

If you have configured the Y-Axis to display only integer values, but it scales the overall axis to a small range like 0-2 and you have more than 3 major ticks you will not be able to display the numerical values of 0, 0.5, 1, 1.5, 2 that would happen if you have 5 major ticks with labels.

If your Y-Axis number format is 0 or # you will see 0,0,1,1,2 which would seem to be the symptom you are describing. Make your format 0.0 for the Y-Axis labels.

Regards,

Jeremy Good

Former Member
0 Kudos

Jeremy,

You are close about the problem I am facing.

Heres what I am seeing on y-axis 0,0,1,1,1,2,2,2,3,3,3.

Here are my setting on y-axis.

Number Format 0.0

Major Tick count 10

Minor Tick Count 5

Ticks Per Label 1

Show Tick Marks X

Show Labels X

Draw 3D X

Use pen Color X

Setting on Pen Details

Use Global Decimals X ( Which is 0 )

Use global Ranges off

Global Auto Scale X

Global server scale off

Zero base scale X

For pen1

Auto Scale off

Server Scale off

I am not sure where I did wrong. I thought I know the answer as it appears to be simple settings related to issue. Unfortunatly it turned into ...etc.

Thanks,

Srinivas.

jcgood25
Active Contributor
0 Kudos

The default behavior would be for the Y-Axis to show two decimals. Try using the iChart's right click Display Properties...Chart Properties dialog and setting the YAxisNumberFormat (in the String Settings list) to 0.0 or 0.00 and then press the OK button to see the immediate effect. Once you get the needed setting then make the permanent change in the Display Template.

Regards,

Jeremy

Former Member
0 Kudos

Jeremy,

When I changed Y Axis Number format to 0.00. If showed following values on y - Axis. 0.00,0.40,0.80,1.20,1.60,2.00,.....

I know whats the math going on server. It is dividind max range with no of horizantal lines in general tab. Is there any way to know whats the max value in a column. So that I can set Horizantal grind lines and global max range in javascript update event.

Thanks,

Srinivas.

jcgood25
Active Contributor
0 Kudos

Srinivas,

Did you look in the Script Assistant?

The iChart has the following two methods:

document.APPLET.getChartObject().getEffectiveMinRange(PenNumber);

document.APPLET.getChartObject().getEffectiveMaxRange(PenNumber);

If you are using AutoScaling, this will tell you how 'tall' the first pen or the first bar is and you should be able to determine the appropriate format of the YAxis or the number of Major ticks to set and then do a document.APPLETNAME.updateChart(false);

Regards,

Jeremy Good