질문하기

gbilodeau's profile - activity

2017-02-27 21:57:42 +0200 받은 배지  학생 (source)
2017-02-27 21:57:15 +0200 받은 배지  유명한 질문 (source)
2016-02-03 00:44:43 +0200 받은 배지  유명한 질문 (source)
2015-08-25 07:10:33 +0200 받은 배지  주목할 만한 질문 (source)
2015-08-24 21:19:01 +0200 받은 배지  인기있는 질문 (source)
2015-08-24 21:19:01 +0200 받은 배지  주목할 만한 질문 (source)
2015-07-04 20:06:56 +0200 코멘트달린 답변 Updating pivot table data range

Works like a charm, thanks. Can we push this a step further: as soon as a new row is added to the raw data set, could the pivot table be automatically updated? Something like a dynamic data range?

2015-07-04 18:26:36 +0200 받은 배지  조력자 (source)
2015-07-03 20:56:46 +0200 질문하였습니다 Updating pivot table data range

This is a follow-up question to http://ask.libreoffice.org/en/questio...

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 have created a pivot table with date-time as a rowfield, average quantity as datafield, and grouped data by day. I have also created a line graph based on the pivot table output.

My data set has since grew: the pivot table was created using a data range of A1.B1:A100.B100, it now contains data up to A200.B200. I want two things:

  1. Update my pivot table to consider this new data range
  2. Update the graph to consider the updated pivot table data

I could obviously recreate both the pivot table and graph, but I would like this to be easier. Can this be done otherwise?

Thanks again!

2015-06-29 20:48:13 +0200 받은 배지  인기있는 질문 (source)
2015-06-29 20:05:32 +0200 받은 배지  학자 (source)
2015-06-29 05:27:20 +0200 질문하였습니다 Daily statistics

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:

  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?

Thanks!