Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/Qlik_Jira_Time_Formattings.qvs

Created November 15, 2017 16:24
Show Gist options
  • Save ralfbecher/4a862f017df70e15ad855e31f71e429a to your computer and use it in GitHub Desktop.
Save ralfbecher/4a862f017df70e15ad855e31f71e429a to your computer and use it in GitHub Desktop.
Download ZIP
Qlik JIRA Time Formatting
Raw
Qlik_Jira_Time_Formattings.qvs
// Format a time like in JIRA: 4w 3d 06:30
// means: 4 weeks + 3 days (1 day = 8 hrs) + 6 hrs + 30 mins
If(Floor(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/5 >= 1,
Num(Floor(Floor(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/5), '#0') & 'w ', '') &
Num(Frac(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800/5) * 5, '#0') & 'd ' &
Interval(Frac(Sum(AllIssues_fields_aggregatetimeoriginalestimate)/28800)/3, 'hh:mm')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment