How to aggregate more rows in a straight table

[arnould_it]

Hello to everyone,

I've to aggregate more rows by the same TimeStamp, now exposed as shown below:

The 2 intermediate rows have to be unified in just 1 row.

Can I do this directly in the table? or I've to do this using script?

Thank you in advance

Alessandro

[tresesco · Accepted solution]

What if you use calculated dimension instead of the the field? Try expression like:

Timestamp(Floor(TimeString_mm, 1/24/60), 'DD:MM:YYYY hh:mm')

[arnould_it]

I've provided to upload a sample app, just waiting for the approval.

Menawhile you can see below another screenshot.

The red squared rows have to be aggregated in just 1 row:

[tresesco]

Have you tried the way as I suggested above using floor() ?

[arnould_it]

Hi Tresesco,

I've tried and it seems working well, I'll apply it on the entire app and test all.

Thanks a lot

Alessandro