Announcement

Collapse
No announcement yet.

Add Label to Report and disable column only on chart

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Add Label to Report and disable column only on chart

    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

  • #2
    Hi,

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

    Comment


    • #3
      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

      Comment


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

        Example for hours:


        Code:
        TIMESTAMPDIFF_HOUR:(dateEnd, dateStart)

        Comment


        • #5
          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?

          Comment

          Working...
          X