Add Label to Report and disable column only on chart

[jurnet]

Hi,
I have bought the Advanced Pack and I have 2 Questions.

First : It' is possible to add a label to a column ?
For example , I have 2 Column on my report, the first is Count and the second is SUM:MyField
I want to rename Count by Number of XXX and SUM:Myfield by TOTAL

Second : It is possible to disable a column only on the chart ?
For example: I have the 2 columns above but on the chart I only want TOTAL

Thanks for your time

[yuri]

Hi,

Unfortunately there are no such abilities. I will think about implementing the second one.

[jurnet]

Is there the ability to choose the time unit for the average ?
For example, I have the average of call group by direction but it's in second. I'd like to convert it in hours:minutes.
Is it possible ?

Thanks

[yuri]

If you group by duration you can use complex expression:https://github.com/espocrm/documentation/blob/master/docs/user-guide/complex-expressions.md

Example for hours:

TIMESTAMPDIFF_HOUR:(dateEnd, dateStart)

[jurnet]

Hi,
I have 2 New Question because it doesn't work.
As you can see on my screenshot.
First I want to add new column a the end (file:c.png) with the total of the sum of average

Second I want to make your complex expression (a.png and b.png) but it doesn't work. As you can see there are 8100 on the average duration but I want 2h15min How can i do this?