Axes labels are not properly displayed in scatter plot incase of negative values
I have 2 views V1 and V2 with left outer join. in report i have dragged all the required column from both the views. Now I have to create a calculate field on top of the table fields.
I have created a simple calculated field with case statement. there are 2 fields used in this statement column1 and column2 which are available in the table. This fields is calculated in the master query. so that the case statement should be implied in outer query.
e.g. calculated_field==> case when column1= 'Abc' then -1 else column2 end
(select column1,column2.... from table1 t1
on t1.column3= t2.column3
and after that i tried to create scatter plot using calculated_field and e.g. column4.
But the axes labels are not showing properly. can you please help me on this.
This is urgent.
Please help me ASAP.
Attaching screenshot for reference.