I’m using LibreOffice Calc 4.3.1.2 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:
- Daily count (how many values within a given day)
- Daily average (average quantity within a given day)
- Daily count graph
- Daily average graph
I just cannot figure how to do this. Is this at all possible?
Thanks!