aguest Posted July 15, 2015 Share Posted July 15, 2015 I've got a table with raw data in it that contains a data and Grade. I've created two calcualtions also wihtin this table for AcademicTerm, which translates the date into an equivalent school term, the other is a summary field which basically counts the Grade field. I want to chart the grades over time (grades range from 1 to 4)through the use of a line chart. What I've done so far, is through the use of a script, summarise the data (chartdata) into a layout (chartdatasumm) which is based on a temp table where the data gets deleted everytime the script runs. I've then tried to chart this and it kindof works. Chartindiv show what I want (ish) but it has the term repeated across the x axis for each record, and ChstSummary just shows the first row from each term. Is there an easy way to get what I want without having to transpose my data so that my Grades (1-4) are four columns instead of rows? I hope that makes sense. TIA Link to comment Share on other sites More sharing options...
eos Posted July 15, 2015 Share Posted July 15, 2015 See if the attached file helps you LineChartSQL_eos.fmp12.zip. Link to comment Share on other sites More sharing options...
aguest Posted July 16, 2015 Author Share Posted July 16, 2015 HI Eos, That is exactly what I'd like but the lines flipped so the term is the x axis and the lines show the grades. I can't get this to work for me though. Are you able to explain it as I can't see how it's been done as I can't go into edit mode in the layout. TIA Link to comment Share on other sites More sharing options...
eos Posted July 16, 2015 Share Posted July 16, 2015 That is exactly what I'd like but the lines flipped so the term is the x axis and the lines show the grades. Right; check out this attached file; and … I can't see how it's been done as I can't go into edit mode in the layout. … that is probably a problem with OS level permissions under Windows which sometimes seem to get scrambled when unpacking a zip archive that was created on a Mac. Make sure you have write permission on the file; the database itself has the default Admin account. LineChartSQL_eos.fmp12.zip Link to comment Share on other sites More sharing options...
aguest Posted July 16, 2015 Author Share Posted July 16, 2015 thank you that's fantastic. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3211 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 accountSign in
Already have an account? Sign in here.
Sign In Now