Jump 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.

Weekly Sales

wireshop
in Relationships

Featured Replies

I have a database containing order data. I would like to have another table that would have:

WeeklySales

Date

right now I calculate the weekly sales figure in my sales order database. But when I export the numbers I end up with many duplicates of the same info.

The idea here is to create a table that I can use to make charts easily. Ideally in FusionCharts.

Thanks in advance for your advice

A little more information is needed here. You can generate a report and export from that with grouped data or you can even pump it out to a temp table and then export it from that... But without more info I dont thin kwe can help more better.

  • Author

What I need is a table of weekly sales figures.

for example:

weeklySales::FirstDayOfWeek

WeeklySales::Sales

What I don't understand is how to pull this data from my sales order table in which I have

SalesOrders::Total

SalesOrders::OrderDate

Create an account or sign in to comment

https://fmforums.com/topic/60875-weekly-sales/
Go to topic listing

Important Information

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

I accept

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.