How to aggregate multiple periods of time in a table

  • 1
  • Question
  • Updated 2 years ago
Hi All

I am trying to build a simple report table based on Scaffolding data. The report table needs to look for identical entries in the Scaffolding table-data e.g. column1 and group some date-data in the report table.

I am able to do the grouping (using grouping-reporter and grouping-stats) for number-data but not for date-data...??!! 

Does anyone know how to do it?

Below a snapshot of working report table for number-data:



A snapshot of result (just for clarification):

Hmm, what I have tried (among other experiments) for date-data is:

But it does not work.

I need the report table to calculate durations of time between two dates (columns: start and end). I the same entry in Scaffolding e.g. column1 is found, the report table must collapse these into one single row and calculate the aggregate the total (sum) of durations of time for the entry in question.

Any help on this is highly appreciated.

Cheers,

Anders
Photo of Anders Felter

Anders Felter

  • 7 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1

There are no replies.