Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pie chart in which I have calculated the legend colors in the background.. . I have grouped all the null values to a color but not sure in the chart why again null values are coming in a different color.. Actually I have grouped all the null values under ABC with my script..
Any help would be greatly appreciated..
if you see "-" is because you still have null values! Can you post your application so we can work on the script?
Hi,
Can you post your expression that you have used to group under abc?
Celambarasan
Hi,
I am attaching the expression that I have usedin the Scripting.. Not able to attach the sample issues due to confidentiality..
Plz let me know if u need any info..
In your script I don't see anything assigning NULL values to a color. You need to add 1 more if
if(([Status])='',num(yellow())
To assign Yellow to a null value or do it at the end in an Else clause
You are getting nulls in the "Status" dimension, becuase the expression you have used for the "Total" is including fields from a different table, and some of those field values (totalled as 271 in your case) do not have any corresponding Status.
e.g. say, if your "Total" expression is Count(Employees) then from your chart it appears that 271 employees do not have any corresponding "Status"
So it may make sense for you to just tick the "Suppress when value is Null" option of the dimension properties.