Ask Your Question

VirtualMechanic's profile - activity

2019-09-25 19:10:34 +0200 received badge  Famous Question (source)
2019-09-25 19:10:34 +0200 received badge  Notable Question (source)
2018-11-17 09:18:06 +0200 received badge  Popular Question (source)
2018-11-17 00:07:03 +0200 marked best answer Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

I am trying to create a fairly simply pivot table to quickly compile and break down some numbers from our ticketing system. The original file format was .CSV, which I saved as .ODS to edit and what not.

I set the format of the data fields as I would like them (eg. open date = DD-MM-YYYY HH:MM:SS).

Pivot table settings:

image description

Example data:

image description

The result:

image description

The desired result:

image description

Meaning an overview per day of the average response time.

I cannot get this to work for the live of me. I have used the same function in Excel, which worked fine (with the same source data) but somehow can't get it to work in LibreOffice Calc.

2018-11-17 00:07:03 +0200 received badge  Scholar (source)
2018-11-17 00:06:21 +0200 commented answer Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

Thank you!

2018-11-17 00:05:30 +0200 received badge  Supporter (source)
2018-11-17 00:05:16 +0200 edited answer Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

I parcially resolved the issue. I got the data to show in the Response Time by loading in a fresh .CSV and made sure the

2018-11-17 00:03:40 +0200 commented answer Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

Thank you very much! I found an even easier way to get the date/time format right, which was ticking the box 'Detect se

2018-11-16 23:36:51 +0200 received badge  Self-Learner (source)
2018-11-16 23:36:51 +0200 received badge  Teacher (source)
2018-11-16 23:15:52 +0200 answered a question Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

I parcially resolved the issue. I got the data to show in the Response Time by loading in a fresh .CSV and made sure the

2018-11-16 22:57:41 +0200 received badge  Organizer (source)
2018-11-16 22:55:06 +0200 asked a question Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty

Pivot table - date/time not compiling and avg time (hh:mm:ss) showing empty I am trying to create a fairly simply pivot