Time Duration counting report

[PavelZ]

Hi,
Advanced Pack - Report : Type : Grid
If I want to sum the time of all meetings. I use SUM: Duration
The resulting value is not a time but a number.
Instead of 5 minutes I get the number 300.

ESPOCRM: 8.0.5
Advanced Pack: 3.0.15

[yuri]

Hi,

This is not a bug. There's no ability to display duration in h:m. It displays actual values that are in seconds.

[yuri]

In the future, we will have the ability to define complex expressions for columns. It will allow to convert result data using functions.

[PavelZ]

OK, thank you.

[yuri]

Will be possible in v3.1.

[Kharg]

Hi Yuri, what about a feature to show actual values compared to target values in charts?

[yuri]

You can already do it with Joint Grid Report.

Custom entity type called RevenueTarget, with a date and amount fields.

The first report groups by RevenueTargets by MONTH:date.
The seconds report is revenue by month.

[PavelZ]

If the total number of seconds is 6900, I get 2 hours. Is it possible to divide without rounding?

[PavelZ]

I found a solution: FLOOR: (SUM: (DIV: (duration, 3600)))