how to set select a specific part of data for charts
I have build a system with different productionlines in it. For each productionline a questionaire is filled in every day.
Based on these answers a rating is calculated on a weekly bases.
I would like to show the weekly ratings for each subjects (the questions discuss 5 subjects) in a bargraph.
the bargraph for each subject I have but now I would like to show the bargraph only the last 10 weeks of ratings instead of
all the ratings (app 25 weeks now).
I would like to know where I can find the info to build it.
thanks a lot.
If each data point (rating in your case) is a separate record, not individual fields in the same record, you should be able to perform a find to limit the records to the desired set of data points and then your chart can be set up to chart just those data points.