Time Duration counting report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PavelZ
    Member
    • Jan 2023
    • 30

    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
    ​​
  • yuri
    Member
    • Mar 2014
    • 8453

    #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 if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • yuri
      Member
      • Mar 2014
      • 8453

      #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 if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment

      • PavelZ
        Member
        • Jan 2023
        • 30

        #4
        OK, thank you.

        Comment

        • yuri
          Member
          • Mar 2014
          • 8453

          #5
          Will be possible in v3.1.

          ​​Click image for larger version

Name:	image.png
Views:	168
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 if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          Comment

          • Kharg
            Senior Member
            • Jun 2021
            • 410

            #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:	174
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.
          • PavelZ
            Member
            • Jan 2023
            • 30

            #7
            Click image for larger version

Name:	image.png
Views:	134
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

            • PavelZ
              Member
              • Jan 2023
              • 30

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

              Comment

              Working...