Ask Your Question

Daily statistics [closed]

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

gbilodeau gravatar image

updated 2020-08-22 17:47:33 +0100

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-22 17:47:50.368181

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 732 times

Last updated: Jun 29 '15