Hi :) I was thinking about a 2nd Query to get the average/month rather than using the 1st Query. Alex has a better idea i think.
As for using Calc i thought the idea was to use something like; Insert - Data Source but i could only find linking to "External data". I didn't think that just dragging the Query into Calc would work. I'm guessing that if the original data now gets updated the ex-Query in Calc wouldn't update? At least it's given a basic idea of what to expect though. I don't know how to get Calc to generate reports based on Queries within Base but i really should. Apols and regards from Tom :) On 26 September 2014 10:03, Don Parris <[email protected]> wrote: > Thanks Alex. The underlying query gets the month from the date, as well as > the total, average, max and min for each month. The results are, of > course, already grouped & calculated by month. I was able to get the > overall total, but also wanted to see the overall average, max and min. I > somehow imagined that it would be a piece of cake. It looks like Calc is > the better "report tool" in this case. > > In Calc, I dragged the query into a spreadsheet, and simply created a > series of formulas to perform the calculations on the results. > > If I alter the query, how can I get the overall average, apart from the > monthly averages? > > Thanks, > Don > > On Fri, Sep 26, 2014 at 3:45 AM, Alex Thurgood <[email protected]> > wrote: > > > Le 25/09/2014 23:59, Don Parris a écrit : > > > > > > Hi Don, > > > > > shown, and that works great. I used the "Accumulation" function to do > > > this. But when I try to get an overall average, I wind up getting the > > > average for the first month (in the report), not for the year-to-date. > > > > > > > What expression are you using in the definition of your Report Builder > > field to obtain the average of all months combined ? If you just use > > something like AVG[MONTH] then it will only average on that particular > > month. > > > > It might be better, as Tom has suggested, to create a separate result in > > your initial query in order to provide the average of the combined > > months rainfall. > > > > > > Alex > > > > > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > D.C. Parris, FMP, Linux+, ESL Certificate > Minister, Security/FM Coordinator, Free Software Advocate > http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> > <http://www.linkedin.com/in/dcparris> > GPG Key ID: F5E179BE > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
