Start a new topic

Misleading y-axis in charts

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I frequently see that y-positions of points in charts are not displayed in their proper locations, and sometimes charts' y-axis do not make sense. The attached chart is a trivial example that was created with the following code (with Vertica DB, if that matters): create table VADIM.T(x Numeric, y Numeric); insert into VADIM.T values (1, 1); insert into VADIM.T values (2, 2); insert into VADIM.T values (3, 2.5); insert into VADIM.T values (4, 3); insert into VADIM.T values (5, 3.5); select * from VADIM.T order by x; The grid view displays data correctly: x y 1.000000000000000 1.000000000000000 2.000000000000000 2.000000000000000 3.000000000000000 2.500000000000000 4.000000000000000 3.000000000000000 5.000000000000000 3.500000000000000 The chart of y versus x is looking rather strange though: - the y-axis has three repeating "2" labels, - and the last point is displayed as it has y value of "4" while its actual y value is 3.5. It would be nice to have the basic data visualization working properly.

[This reply is migrated from our old forums.]

Re: Misleading y-axis in charts
Hi, We will look into this. Regards Roger
[This reply is migrated from our old forums.]

Re: Misleading y-axis in charts
Vadim, Is this you experience just occasionally or all the time? If randomly, do you see any pattern when it happens? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Misleading y-axis in charts
I would say it happens randomly and fairly frequently, but I didn't use the chart view that much to notice any significant patterns. Except, maybe, that the trends seem to look right but the labels sometimes get messed up.
[This reply is migrated from our old forums.]

Re: Misleading y-axis in charts
Vladim, This is fixed by editing the chart properties for the Y-Axis. Setting Number Format to #,##0.# will show fractions. You can save this as default using the Settings drop-down button in the chart properties dialog. Read more in: http://confluence.dbvis.com/display/UG92/Working+with+Charts#WorkingwithCharts-AppearancePreferences Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Misleading y-axis in charts
Thanks! That works. However, would it be possible to also have a default "auto" format setting that would show reasonable labels depending on the numeric range? Also, an option to change the labels' font size and the x-axis numeric format would be useful to make plots more presentable.
[This reply is migrated from our old forums.]

Re: Misleading y-axis in charts
Vladim, I will open a new ticket for your requests. Regards Roger