7 Replies Latest reply: Jan 27, 2012 6:19 AM by Robert Svebeck RSS

Uncheck "supress zero values" in my Extension object ?

Robert Svebeck

Hi.

 

Again, possibly a simple question from a novice...


In a ordinary chart, I can uncheck "Supress zero values" which will let me see all dimensions even if the expression has nothing to calculate for a specific value in the dimension.


If I have two tables like this:


TableA
ID, Descr
A,  Alfa
B,  Beta
C,  Gamma


TableB
ID, Qty
A, 10
A, 20
A, 50
B, 10
B, 40


I make a simple chart with a simple sum(Qty) expression, and with ID as dimension.
I uncheck "Supress Zero values" -> I will see all three values of ID (A,B,C) and the sum of Qty for each (80,50,-)


I can not find how to uncheck "supress zero values" in my extension object. When I loop my data like this:


for (var rowIx = 0; rowIx < myData.Rows.length; rowIx++)
{
var row = myData.Rows[rowIx];
alert (row[0].text + " - " + row[1].text);
}


I see that I get only 2 rows, A and B and nothing at all for dimension 1 value C. This is kinda expected behaviour for a normal chart when "supress zero" is checked, but How do I not supress zero values for a extension object?

Best Regards,

Robert Svebeck