{"action":"created","issue":{"url":"https://api.github.com/repos/TransNexus/NexOSS/issues/22","repository_url":"https://api.github.com/repos/TransNexus/NexOSS","labels_url":"https://api.github.com/repos/TransNexus/NexOSS/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/TransNexus/NexOSS/issues/22/comments","events_url":"https://api.github.com/repos/TransNexus/NexOSS/issues/22/events","html_url":"https://github.com/TransNexus/NexOSS/issues/22","id":153664635,"number":22,"title":"Need to present Avg Call Duration in hh:mm:ss format","user":{"login":"JimDalton","id":18315382,"avatar_url":"https://avatars.githubusercontent.com/u/18315382?v=3","gravatar_id":"","url":"https://api.github.com/users/JimDalton","html_url":"https://github.com/JimDalton","followers_url":"https://api.github.com/users/JimDalton/followers","following_url":"https://api.github.com/users/JimDalton/following{/other_user}","gists_url":"https://api.github.com/users/JimDalton/gists{/gist_id}","starred_url":"https://api.github.com/users/JimDalton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JimDalton/subscriptions","organizations_url":"https://api.github.com/users/JimDalton/orgs","repos_url":"https://api.github.com/users/JimDalton/repos","events_url":"https://api.github.com/users/JimDalton/events{/privacy}","received_events_url":"https://api.github.com/users/JimDalton/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-08T16:24:08Z","updated_at":"2016-05-11T20:04:50Z","closed_at":"2016-05-11T20:04:50Z","body":"#### Page Title\r\nTraffic Reports and Billing Reports\r\n\r\n#### Legacy URL\r\n\r\n\r\n#### New URL\r\n\r\n\r\n#### Description of issue\r\nAverage call duration and average billing duration must be presented in the format of hh:mm;ss.  If hh=0, then format should be mm:ss.  If mm=0 then the format should be m:ss.\r\nExamples:\r\n12:34:56 - Twelve hours, thirty four minutes and 56 seconds\r\n  2:34:56 - Two hours, thirty four minutes and 56 seconds\r\n     34:56 - thirty four minutes and 56 seconds\r\n       4:56 - four minutes and 56 seconds\r\n       0:56 - 56 seconds\r\n       0:06 - 6 seconds\r\nI think we need a new column type.  Suggested name is hhmmss\r\n\r\nIn addition, there are use cases when it is helpful to show fractions of a second in decimal form.  For example:\r\n12:34:56.102 - Twelve hours, thirty four minutes and 56.102 seconds\r\nBest case would be to have new column type such as hhmmss that can also be edited using the columns.x.decimals value.\r\n"},"comment":{"url":"https://api.github.com/repos/TransNexus/NexOSS/issues/comments/218573704","html_url":"https://github.com/TransNexus/NexOSS/issues/22#issuecomment-218573704","issue_url":"https://api.github.com/repos/TransNexus/NexOSS/issues/22","id":218573704,"user":{"login":"JimDalton","id":18315382,"avatar_url":"https://avatars.githubusercontent.com/u/18315382?v=3","gravatar_id":"","url":"https://api.github.com/users/JimDalton","html_url":"https://github.com/JimDalton","followers_url":"https://api.github.com/users/JimDalton/followers","following_url":"https://api.github.com/users/JimDalton/following{/other_user}","gists_url":"https://api.github.com/users/JimDalton/gists{/gist_id}","starred_url":"https://api.github.com/users/JimDalton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JimDalton/subscriptions","organizations_url":"https://api.github.com/users/JimDalton/orgs","repos_url":"https://api.github.com/users/JimDalton/repos","events_url":"https://api.github.com/users/JimDalton/events{/privacy}","received_events_url":"https://api.github.com/users/JimDalton/received_events","type":"User","site_admin":false},"created_at":"2016-05-11T20:04:50Z","updated_at":"2016-05-11T20:04:50Z","body":"E-Mail from Dmitry 2016-05-11\r\nThe value for Avg Call Duration in Reports is sent as a formatted string.  \r\n\r\nFor example the ACD for top row of the report @ http://172.16.4.93:9080/ui2/Fraud-Control/CDR-Analytics-Basic/By-Customer-Device/Theft-of-Service/Trigger-Report is 3:30\r\n\r\nThe UI displays it as N/A probably because the column data-type is configured as a number.  It should probably be configured as a string.\r\n\r\nSolution for this requirement is to format Avg Call Duration in Reports as type=text, align=right\r\n\r\nHow Avg Call Duration should be formatted for Trigger pages and Trigger Event Pages is still to be determined."}}