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.

Charting: Problems with Months

Featured Replies

  • Newbies

Dear all, 

 

I'm quite a novice to filemaker and I'm facing a disturbing problem with the chart feature. 

 

My goal is to create a database where I record the number of products that I've sent during each month of the last year to the different countries where my customers are based. I've also created a Report, that tells me exactly the quantities per country, with a sub-summary (month) and a sub-total that indicates the monthly quantities shipped. 

 

The tables are:

 

- Country

- Orders

   * month_orders (join table of orders)

   * unique_orders (join table of orders)

- Orders Line Item

- Products

 

 Things are becoming tougher know that I want to add a chart that shows the monthly quantities per country. This means that every time that I try to put on the x axis the month (for instance: the cMonth field based on unique_orders table) the result I get is all the month of every single country and the same happens with the order quantity. So instead of having, for example, 5 bars indicating the quantities shipped in Germany, I have 40 bars, one for country. 

 

This means that once that I've put on the X axis the month (for instance: the cMonth field based on unique_orders table) and on the Y axis the order, the results I get is a bar chart indicating a value for every single country and a mix of month.  So instead of having, for example, 5 bars indicating the quantities shipped in Germany, I have 40 bars, one for country and a repeating number of months. 

 

How can I avoid this problem? Thanks for replying. 

 

Ps. I apologize for my english and  for not having the opportunity to upload a file. 

 

Michel

Create an account or sign in to comment

Important Information

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

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.