Figuring the Mode

For HanDBase related topics that are not specific to one platform.

Figuring the Mode

Postby kmorris » Thu Jul 16, 2009 3:02 pm

Is it possible, either directly or through convoluted field usage to calculate the MODE for a number of records?

e.g. I have a Field X which holds a number from 1 to 10. For the latest weeks worth of records, I want to be able to determine the Mode instead of the Average.

Doable?

Thanks,
Kim
kmorris
 
Posts: 7
Joined: Thu Jul 16, 2009 2:41 pm

Re: Figuring the Mode

Postby dhaupert » Fri Jul 17, 2009 3:51 pm

Hi Kim,

That's a great question! I spent a good deal of time today trying to come up with a solution for this using mutliple calculations and conditionals and came up ultimately empty without adding additional functionality. The HanDBase application on some platforms has a run report feature and this would be a more likely place to see this behavior implemented in the future.

Sorry!
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: Figuring the Mode

Postby kmorris » Fri Jul 17, 2009 6:07 pm

I was afraid of that. Thanks for looking into it for me though!

I'm on the Palm platform, so having this as a report option would be great.

Thanks again,
Kim
kmorris
 
Posts: 7
Joined: Thu Jul 16, 2009 2:41 pm


Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests

cron