Announcement

Collapse
No announcement yet.

Time Duration counting report

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

  • PavelZ
    replied
    I found a solution: FLOOR: (SUM: (DIV: (duration, 3600)))

    Leave a comment:


  • PavelZ
    replied
    Click image for larger version

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

    Leave a comment:


  • yuri
    commented on 's reply
    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.

  • Kharg
    replied
    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:	146
Size:	208.2 KB
ID:	101807

    Leave a comment:


  • yuri
    replied
    Will be possible in v3.1.

    ​​Click image for larger version

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

    Leave a comment:


  • PavelZ
    replied
    OK, thank you.

    Leave a comment:


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

    Leave a comment:


  • yuri
    replied
    Hi,

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

    Leave a comment:


  • PavelZ
    started a topic Time Duration counting report

    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
    ​​
Working...
X