TomC Posted February 22 Share Posted February 22 Hello, Is there a way for Hornbill to present data in other formats or an expression that can be used to change the data output format? For example, Resolve time currently comes out in seconds, whereas it would be more effective for my reports to be presented in Minutes or Hours, especially as I am trying to automate reports so I want to avoid having to manually manipulate the data from seconds into hours. I am currently using the reporting feature within Service Manager to produce my reports. Any advice would be helpful, thanks. Link to comment Share on other sites More sharing options...
Steve Giller Posted February 28 Share Posted February 28 MariaDB has a SEC_TO_TIME() function that may assist here. Link to comment Share on other sites More sharing options...
Jim Posted March 9 Share Posted March 9 @Steve Giller where are we able to use this feature in the reports? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now