Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculate Average Orders per Day?

specpharm
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hiya All,

This is probably dead easy but it's got me a little stumped.

I've got a table that holds a record for every order we receive. It contains a date field that holds the date the order was created. I'd like to be able to calculate the average number of orders per day.

It seems simple enough to calculate how many orders came in on any given day - self-join based on date field, calc field with count (Join Table::) Date).

But getting an average of that calc field would give a completely skewed result since a day with 6 orders would be counted 6 times, etc.

Is there any way of doing this? Optimally I'd like to put all the dates in a portal showing how many orders each one had ...

Any help would be greatly appreciated!

  • 5 months later...
  • Newbies

Did you finally got the way to do it??/ I have the same issue with a project right now..

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.