Time Duration counting report

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • PavelZ
    Member
    • Jan 2023
    • 30
    #1

    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 Photos
    Tags: None
    • 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
                          #6.1
                          yuri commented
                          01-21-2024, 12:16 PM
                          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

                                Previous template Next
                                Working...