Question with a cummulative formula problem. 1

[snazzyCrunch]

I am using CR8.5.

I have an ODBC connection to a performance DB that houses info in the following format....

DATETIME | SERVERNAME | TOTAL_ANONYMOUS_USERS

The column TOTAL_ANONYMOUS_USERS is a cummulative field. Thus, it is always a GRAND_TOTAL of how many anonymous users have ever been on the web server. It is always increasing.

My task is to create a report showing a line graph of the number of anonymous users of time.

My x-value will be my DATETIME value which is fine.
My y-value needs to be:

CurrentRecord.TOTAL_ANONYMOUS_USERS - PreviousRecord.TOTAL_ANONYMOUS_USERS

This will give me the number of users on the server for that particular interval. Any ideas on how this can be done?

Thanks in advance,
snazzyC.
:~/

 

[synapsevampire]

Create a formula with:

if not onfirstrecord then
{Table.TOTAL_ANONYMOUS_USERS} - Previous({Table.TOTAL_ANONYMOUS_USERS})
else
{Table.TOTAL_ANONYMOUS_USERS}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com