AnsweredAssumed Answered

Data from two tables on one chart

Question asked by RyanAshton on Dec 19, 2017
Latest reply on Dec 21, 2017 by RyanAshton

I am an FMP novice.

 

I am trying to get the data from two different tables to display - either on the same chart or on two charts on the same layout (I have figured out a way to add transparency so that one can see the data from both charts) - but on one chart would be better.

 

The first table (Training stats) shows training sessions I've done (running, cycling and swimming).  Each session has a date and a length (in time).  The other table (Training schedule) has the days of the week where I can change the amount of training that I want to do on any particular day.  Essentially "Training schedule" is what I want to do and "Training stats" is what I actually did - last week.

 

I have a Calculation Field on "Training stats" that shows the names of the days from last week of days that I did training on with the calculation:

 

If ( Week  <  Get ( CurrentDate ) - Mod ( Get (CurrentDate) - 1 ; 7)  and Week  ≥  Get ( CurrentDate ) - Mod ( Get (CurrentDate) - 1 ; 7) - 8 ; DayName ( Date ) ; "" )

 

 

I want the graph to show:

 

Mon - Tues - Wed - Thurs - Fri - Sat - Sun

 

with the stats from each table on it.

 

Any ideas how I can do this?

 

Thanks for your help.

 

 

Mery Xmas,

 

Ryan

Outcomes