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.
    If you find EspoCRM good, we would greatly appreciate it if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    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.
      If you find EspoCRM good, we would greatly appreciate it if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment


      • #4
        OK, thank you.

        Comment


        • #5
          Will be possible in v3.1.

          ​​Click image for larger version

Name:	image.png
Views:	166
Size:	15.7 KB
ID:	101788
          Last edited by yuri; 01-20-2024, 03:01 PM.
          If you find EspoCRM good, we would greatly appreciate it if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          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:	172
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:	129
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