AnsweredAssumed Answered

Report creation issue

Question asked by stephcourdin on Dec 15, 2016
Latest reply on Dec 15, 2016 by philmodjunk

I was hoping to create a single report layout and display a chart for each individual activity type

( so the chart needs to have a filter)

 

the resulting report would have a total of 6 charts

 

New to report generation in FileMaker (i'm very familiar with SQL and BI tools which allow you to generate reports and modify the sql expression to get the desired result-set to display)

 

I have an Activity Table (GUID,Type,Date,Measurement) storing many activities measurements occurring at different dates by type

screenshot(1)Screen Shot 01.png

 

In a regular table layout i can apply a find filter and get the expected results

screenshot(2)Screen Shot 02.png

 

when i try and do the same in a report layout with a chart i do not get the expected results

-- something with the filter seems to cause an issue

-- does not seem to apply the filter and end up with gapped rows

screenshot(3)Screen Shot 03.png

Outcomes