Ask Your Question

Daily statistics

asked 2015-06-29 05:27:20 +0200

gbilodeau gravatar image

updated 2015-08-25 07:10:54 +0200

Alex Kemp gravatar image

I'm using LibreOffice Calc on MacOS Yosemite, all English.

I have a very simple data set: column A is a date-time (YYYY-MM-DD HH:MM:SS) and column B is a quantity (number). I would like to gather some daily statistics on this data set:

  1. Daily count (how many values within a given day)
  2. Daily average (average quantity within a given day)
  3. Daily count graph
  4. Daily average graph

I just cannot figure how to do this. Is this at all possible?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-29 08:14:24 +0200

karolus gravatar image


goto →Data→Pivottable....

-- drag&drop datetime to rowfield
-- drag&drop quantity to datafield, doubleclick and change to average
-- again the previous but without change
hit ok

in Pivottable output click int one datetime cell and goto →Data→Group and Outline→Group ...(Date -- Duration 1 day)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-29 05:27:20 +0200

Seen: 687 times

Last updated: Jun 29 '15