Announcement

Collapse
No announcement yet.

Time Duration counting report

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

  • Time Duration counting report

    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
    ​​

  • #2
    Hi,

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

    Comment


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

      Comment


      • #4
        OK, thank you.

        Comment


        • #5
          Will be possible in v3.1.

          ​​Click image for larger version

Name:	image.png
Views:	103
Size:	15.7 KB
ID:	101788
          Last edited by yuri; 01-20-2024, 03:01 PM.

          Comment


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


            Click image for larger version

Name:	image.png
Views:	106
Size:	208.2 KB
ID:	101807

            Comment


            • yuri
              yuri commented
              Editing a comment
              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.

          • #7
            Click image for larger version

Name:	image.png
Views:	57
Size:	102.8 KB
ID:	103287
            If the total number of seconds is 6900, I get 2 hours. Is it possible to divide without rounding?

            Comment


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

              Comment

              Working...
              X