I have a table containing the values (-4,0) (-3,0) (2,0) (5,0)
The columnchart represents the x-values as 4, 3, 2, 5 (in that order)
So: without the minus-sign!
(The piechart is working well, i.e. showing the negative values)
I have a table containing the values (-4,0) (-3,0) (2,0) (5,0)
The columnchart represents the x-values as 4, 3, 2, 5 (in that order)
So: without the minus-sign!
(The piechart is working well, i.e. showing the negative values)
Could you show the report code?
--
myDBR Team
The first one is showing on the x-axis 4, 3, 2, 1, 0, 1, 2, 3, 4
select 'dbr.chart.color', 'FF0000', 'D60000', 'FF5252', 'FF8000', 'FF9E3D','FFC78F', 'FFFF8F', 'C7FF8F', '8FFF8F', '00A300' ;
select 'dbr.chart','Column','Verschillen eerste en laatste metingen in aantallen';
select 'dbr.chart.options','axis', 'Verschil eerste en laatste meting', 'Aantal';
select *
from tmp_verschillen_conclusie tv
group by tv.Verschil1
order by tv.Verschil1
;
select 'dbr.chart.color', 'FF0000', 'D60000', 'FF5252', 'FF8000', 'FF9E3D','FFC78F', 'FFFF8F', 'C7FF8F', '8FFF8F', '00A300' ;
select 'dbr.chart','Pie','Verschillen eerste en laatste metingen in percentages';
select 'dbr.chart.options','axis', 'Verschil eerste en laatste meting', 'Aantal';
select 'dbr.chart.options', 'showvalues', 'percent';
-- select 'dbr.colstyle',1,'%.0f;';
select *
from tmp_verschillen_conclusie tv
group by tv.Verschil1
order by tv.Verschil1
;
We'll take a look at it.
Btw, it is always easier if you show the report code using Output as SQL. This way we can recreate the report without having your tables and data.
--
myDBR Team
This has been fixed. Just run the updater.
--
myDBR Team
Thank you.
You must log in to post.