Jump to content

Charting summary fields from related table


thomasjpr
 Share

This topic is 2908 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am using FMP13 to generate reports for clients of the performance of their online advertising. Just some very basic metrics. I have had no problems getting the parts to summarize the metrics for all ads of a certain type (display, search, etc.).

 

I am also trying to display charts showing a monthly breakdown -- this is where I'm having an issue. The monthly metrics are in a related table, the records of which are created through a portal in the ad campaign editor. 

 

My charts are only charting months for the first record of each ad type, not summarizing totals for each month of each ad type as I had hoped. What's the missing piece here? I've tried different parts and everything that I can think of. This is possible right? Hopefully you can make sense of this. Thanks! 

Link to comment
Share on other sites

Hi Thomas, welcome to FMForums!  :-)

 

When looking to a related table (monthly metrics), FileMaker only sees the first related record which probably explains why you get one result each.  It sounds like the chart should be generated in the monthly metrics table itself but it would help if you could zip and attach a simple file demonstrating the issue.

Link to comment
Share on other sites

This topic is 2908 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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