Reports: Status expressed in a unit of time

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LuckyLouie
    Senior Member
    • Nov 2017
    • 172

    Reports: Status expressed in a unit of time

    Is it possible to make a report in which "Status" will be expressed in a unit of time? For example, "Status: In Process" lasted a total of 3 hours for the selected Leeds?
    Thank You for help!
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hi,
    the way I see:
    - create a new field for this value,
    - set it with a formula for the future,
    - create a scheduled workflow for old leads,
    - use this field for report

    Also you can improve it with additional rate table (like currency and currency concerted fields), but it requires a development

    Comment

    • LuckyLouie
      Senior Member
      • Nov 2017
      • 172

      #3
      Thank you Tanya for replay. What to understand by "create a new field for this value" what type of field? what should contain?

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        time - hours or minutes. Float or integer.
        if I understood you well

        Comment

        Working...