I am having a problem with charts and reports not synchronizing. So I created a test table to see what I am doing wrong, but still seeing the same issue.
Basically, I have a value I want to graph (Amount) over time for each OfficeName grouped by Region.
So on the report, I group by Region, OfficeName and place the chart into the OfficeName header section. In the chart wizard, I set "report" OfficeName= "chart" OfficeName...note, I've tried using the OfficeID as well to no change.
In the screenshot, you can see that the chart is not trying to graph the correct data for the given Office. I used a pivot in the test chart (OfficeName), but will have to remove as in the real data I want to graph 3 values (Amount, bid, ask). Result is the same without the pivot.
For example: The Knoxville Office should have 3 data points and the chart only shows 2 (but are also from the wrong office---showing the Nashville Office name and dataset).
I'm not sure what I'm doing wrong, this should be a straight forward task. Using the chart wizard to generate the query and 'map' the OfficeName in the report to the OfficeName in the data (or trying to).
simple table export:
"ID","Region","OfficeName","DateTrial","Amount","O fficeID"
1,"East","Chicago",1/1/2017 0:00:00,$10.00,1
2,"East","Chicago",2/4/2017 0:00:00,$5.00,1
3,"East","Chicago",5/3/2017 0:00:00,$20.00,1
4,"East","Vernon Hills",6/3/2017 0:00:00,$200.00,2
5,"West","Englewood",1/1/2017 0:00:00,$15.00,3
6,"West","Englewood",2/3/2017 0:00:00,$40.00,3
7,"Central","Madison",8/3/2017 0:00:00,$16.00,4
8,"Central","Madison",12/30/2017 0:00:00,$205.00,4
9,"Central","Madison",8/3/2017 0:00:00,$117.00,4
10,"Central","Knoxville",3/15/2017 0:00:00,$57.00,5
11,"Central","Knoxville",6/23/2017 0:00:00,$48.00,5
12,"Central","Knoxville",9/1/2017 0:00:00,$25.00,5
13,"Central","Nashville",3/2/2017 0:00:00,$49.00,6
14,"Central","Nashville",1/1/2017 0:00:00,$58.00,6
15,"Central","Molene",1/1/2017 0:00:00,$38.00,7
16,"Central","Molene",3/2/2017 0:00:00,$35.00,7