[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.
Vadim,
Is this you experience just occasionally or all the time? If randomly, do you see any pattern when it happens?
Regards
Roger
a
anonymous
said
almost 10 years ago
[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.
Roger Bjärevall
said
almost 10 years ago
[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
a
anonymous
said
almost 10 years ago
[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.
Roger Bjärevall
said
almost 10 years ago
[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
anonymous
[Attachment has been removed.]