get total row count/ max

Hi,
i have table with columns
ROWNUM, col1, col2

in onCreate script i want to get count(ROWNUM) or max(ROWNUM)

how can i get max/ count of cloumn in script?

Thanks

Find more posts tagged with

Comments

mwilliams

Hi mh10,

Can you explain more about what you're trying to do, so I can offer the best suggestion?

mh10

Hi Michael, 
I am trying to change color of markers at start & end of line on chart. 
so what i thought to get these first and last values of these points by using ROWNUM column of dataset. 
so in onCreate event of table with this dataset i wanted to get values for fisrt row and last row so that in graph i can use these values in beforeDrawDataPointon() with onRender event. 
 
so that's why i want to know how to get Max(rownum). 
 
Is there any other way to change the color of start and end of markers. 
 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi mh10, 
 
Can you explain more about what you're trying to do, so I can offer the best suggestion?</blockquote>

mwilliams

mh10,

You could probably add another computed column that shows the total count of the dataset. Then, grab that number from the dataset for the last one.

mh10

Hi Michael, 
as you said i created computed column for total row count 
and in onCreate 
 
temp = this.getRowData().getColumnValue("ROW_NUM"); 
tempp = this.getRowData().getColumnValue("MAX_ROW_COUNT"); 
if (temp==tempp) 
{ 
var tempCLm = this.getRowData().getColumnValue("COL_ONE"); 
 
} 
 
 
but when i execute with this it throws Java Null pointer exception, 
while when i put real number instead of 'tempp' like 
if (temp==7) 
 
then it works fine... 
why it is throwing exception with 'if (temp==tempp)' 
 
 
Also, i have two marker points on horizantal line, when i use beforeDrawDataPoint()...both marker get same color...as they have same value...but i want to show different color for each marker. 
How can i differenciate two markers with same orthogonal value, so that i can give each marker different color? 
 
 
Thanks 
 
 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
You could probably add another computed column that shows the total count of the dataset. Then, grab that number from the dataset for the last one.</blockquote>

mwilliams

mh10,

When you set the max count variable, you may need to wrap it in a check for the value being null.

As for the setting a marker a different color that is the same orthogonal value, you can set the color based on the x-axis value as well.

mh10

charts x-axis has values like 
 
'4th month + last 2 months' 
'5th month + last 2 months' 
 
when i used these values with onCreate(), before DrawDataPoint(). 
 
it returns ERROR: 
 
Java.lang.NumberFormatException: For input string '4th month + last 2 months' 
 
 
Any suggestions 
 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
When you set the max count variable, you may need to wrap it in a check for the value being null. 
 
As for the setting a marker a different color that is the same orthogonal value, you can set the color based on the x-axis value as well.</blockquote>

mwilliams

mh10,

Can you set up a .csv database with a sample of your data and a report that uses this flat file database set up just like you want. Then, explain to me what you're wanting to do and I'll try to change that example to work like you want it. This way I can test the report with your data to make sure I can get it to work. Thanks.

mh10

Hi Michael, 
see attached Linechart.zip file. 
i am looking to draw graph as shown on that file. 
 
it has three horizantal line, and i have color markers in like 'T' shape with different color. 
 
Also in Legend i have to show only 4 symbols for each of these colored markers.....hide the initial symbols for the three lines. 
 
 
 
Thanks 
 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
Can you set up a .csv database with a sample of your data and a report that uses this flat file database set up just like you want. Then, explain to me what you're wanting to do and I'll try to change that example to work like you want it. This way I can test the report with your data to make sure I can get it to work. Thanks.</blockquote>

mwilliams

mh10,

Can you attach a flat file of sample data for me to work with in .csv format please? Thanks.

mh10

following fuction helped me in changing any markers color.
it uses x-axis values and series title....to point out marker..

function beforeDrawDataPoint(dph, fill, icsc)
{
// Check if this is the line series (which contains the image marker)
// the series name is hardcoded

if (dph.getSeriesDisplayValue().equals("Series 1"))
{
// get the category value
value = dph.getBaseValue();

// based on category, change the icon url for the marker.
if ( value.equals("4th month 07"))
fill.set(0,255,0);

else if ( value.equals("3rd month 06"))
fill.set(255,255,30);
else
null;
}
}

great!!!!!!!!!!!!!!!

mwilliams

mh10,

Exactly what I was going to set up if I had been able to test it.

Glad you figured it out!