How to exclude null measure values in Chart
user123May 22 2012 — edited May 23 2012Hello Everybody,
I am having a requirement as below.
I have a dimention column ( Month) and a measure column(deviation) in a report.Now the measure column have positive as well as negative values.I have to plot two charts on this same report, where one chart should display the Positive bars, and another only negative bars.
I have actually created two calculated columns as +ve deviation and -ve deviation , as below.
+ve deviation f{x}:
CASE WHEN "fact_table"."Deviation">=0 then "fact_table"."Deviation" END
-ve deviation f{x}:
CASE WHEN "fact_table"."Deviation"<0 then "fact_table"."Deviation" END.
In the chart for displaying only positive bars i am using +ve deviation and vice versa
But in chart i am getting nulls as well in the chart.Is there any other exact solution for this..
An early reply would be appreciated.
Thanks in advance