BugDebug Posted February 27, 2013 Report Share Posted February 27, 2013 Any way I can add a trendline to a chart? I.e. a line that shows what the average value of the bars in a barchart is. Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted February 28, 2013 Report Share Posted February 28, 2013 Have you tried aggregation? http://howto.caspio.com/datapages/creating-datapages/advanced-reporting/totals-aggregation.html Quote Link to comment Share on other sites More sharing options...
0 BugDebug Posted March 4, 2013 Author Report Share Posted March 4, 2013 I have not found a way to use aggregated fields in graphs at all - only calculated fields. With calculated fields, I can calculate something for each record in the record set (currently using that feature to group by week number - from a date) but I don't see how I can use that feature to create a trendline that goes across the chart as know from Excel. Ideas anyone? Quote Link to comment Share on other sites More sharing options...
Question
BugDebug
Any way I can add a trendline to a chart?
I.e. a line that shows what the average value of the bars in a barchart is.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.