Tempo Planner Report Examples

eazyBI for Jira

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Team Hours Weekly Accountability Report",
"folder_name": "Samples Tempo",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Hours spent]"],"members":[]},{"name":"Time","selected_set":["[Time.Weekly].[All Times]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time.Weekly].[Week])","members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Logged by Team","selected_set":["[Logged by Team].[All Logged by Teams]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Logged by Team].[Logged by Team])","members":[],"bookmarked_members":[]},{"name":"Logged by","selected_set":["[Logged by].[All Users]"],"members":[{"depth":0,"name":"All Users","full_name":"[Logged by].[All Users]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","duplicate":true,"selected_set":["[Time.Weekly].[Current week]","[Time.Weekly].[Last 4 weeks]","[Time.Weekly].[All Times]","[Time.Weekly].[Previous week]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time.Weekly].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time.Weekly].[All Times]"]},{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"name":"Issue Type","selected_set":["[Issue Type].[All Issue Types]"],"members":[{"depth":0,"name":"All Issue Types","full_name":"[Issue Type].[All Issue Types]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[All Issue Types]"]},{"name":"Logged by","duplicate":true,"selected_set":["[Logged by].[All Users]"],"members":[{"depth":0,"name":"All Users","full_name":"[Logged by].[All Users]","drillable":true,"type":"all","expanded":false,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Logged by].[All Users]"]},{"name":"Logged by Team","duplicate":true,"selected_set":["[Logged by Team].[All Logged by Teams]"],"members":[{"depth":0,"name":"All Logged by Teams","full_name":"[Logged by Team].[All Logged by Teams]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Logged by Team].[All Logged by Teams]"]}]},"options":{"nonempty":true,"total":"rows"},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Logged by":true,"Logged by Team":true},"cell_formatting":{"[Logged by].[All Users]":[{"background_color":"#EBECF0","text_color":"#2F579C"}]},"freeze_header":true}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Current week","format_string":"","formula":"Aggregate({\n [Time.Weekly].[Week].CurrentDateMember\n})","dimension_hierarchy":"Weekly"},{"dimension":"Time","name":"Previous week","format_string":"","formula":"Aggregate({\n [Time.Weekly].[Week].CurrentDateMember.PrevMember\n})","dimension_hierarchy":"Weekly"},{"dimension":"Time","name":"Last 4 weeks","format_string":"","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('4 weeks ago', 'today')\n)","dimension_hierarchy":"Weekly"}]
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Tempo Hours Planned vs. Hours Spent",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time].[Month])","members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Logged by Team","selected_set":["[Logged by Team].[All Logged by Teams]"],"members":[{"depth":0,"name":"All Logged by Teams","full_name":"[Logged by Team].[All Logged by Teams]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Logged by Team].[All Logged by Teams]"]},{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"name":"Time","duplicate":true,"selected_set":["[Time].[All Times]","[Time].[Last 12 months]","[Time].[Current year]","[Time].[Previous year]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time].[All Times]"]},{"name":"Account","selected_set":["[Account].[All Accounts]"],"members":[{"depth":0,"name":"All Accounts","full_name":"[Account].[All Accounts]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Account].[All Accounts]"]}]},"options":{"nonempty":true},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Hours spent":{"dataLabelType":"top horizontal","color":"#9043C2"},"Tempo planned hours":{"dataLabelType":"top horizontal"}}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Last 12 months","format_string":"","formula":"Aggregate(\n [Time].[Month].DateMembersBetween('12 months ago', 'today')\n)"},{"dimension":"Time","name":"Current year","format_string":"","formula":"Aggregate({\n [Time].[Year].CurrentDateMember\n})"},{"dimension":"Time","name":"Previous year","format_string":"","formula":"Aggregate({\n [Time].[Year].CurrentDateMember.PrevMember\n})"}]
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Gantt Chart for Project Planning \u0026 Progress",
"folder_name": "Samples Tempo",
"result_view": "gantt_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Progress %]","[Measures].[Planning start]","[Measures].[Planning end]","[Measures].[Hours spent]"],"members":[{"depth":0,"full_name":"[Measures].[Progress %]","format_string":"#0.00%","report_specific":true,"name":"Progress %","calculated":true},{"depth":0,"full_name":"[Measures].[Planning start]","format_string":"mmm dd yyyy","report_specific":true,"name":"Planning start","calculated":true},{"depth":0,"full_name":"[Measures].[Planning end]","format_string":"mmm dd yyyy","report_specific":true,"name":"Planning end","calculated":true}]}]},"rows":{"dimensions":[{"name":"Issue","selected_set":["[Issue].[Project].Members"],"members":[{"depth":1,"name":"Open Library","full_name":"[Issue].[Open Library]","drillable":true,"key":"OL","expanded":true,"drilled_into":false}],"bookmarked_members":[]}],"filter_by":{"conditions":[{"expression":["[Measures].[Tempo planned hours]"],"operator":"\u003e","value":"0"}]},"nonempty_crossjoin":true},"pages":{"dimensions":[]},"options":{},"view":{"current":"gantt_chart","maximized":false,"gantt_chart":{"show_key":["Issue"],"left_width":[234.6,200.99375],"timescale":"weekly"},"table":{}},"calculated_members":[{"dimension":"Measures","name":"Planning start","formula":"Filter(\n [Time].[Day].Members,\n ([Time].CurrentHierarchyMember,\n [Measures].[Tempo planned hours])\u003e0\n).Item (0).StartDate","format_string":"mmm dd yyyy"},{"dimension":"Measures","name":"Planning end","formula":"Order(Filter(\n [Time].[Day].Members,\n ([Time].CurrentHierarchyMember,\n [Measures].[Tempo planned hours])\u003e0\n),\n[Time].CurrentHierarchyMember.StartDate,\nBDESC\n).Item (0).StartDate","format_string":"mmm dd yyyy"},{"dimension":"Measures","name":"Progress %","formula":"\n[Measures].[Hours spent]\n/\n[Measures].[Tempo planned hours]\n","format_string":"#0.00%"}]}
} ],
"calculated_members": []
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Planned Assigned Hours vs. Contribution",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Logged by","selected_set":["[Logged by].[User].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Open Library","full_name":"[Project].[Open Library]","drillable":true,"key":"OL","parent_full_name":"[Project].[All Projects]"}],"bookmarked_members":[],"current_page_members":["[Project].[Open Library]"]},{"name":"Fix Version","selected_set":["[Fix Version].[All Fix Versions]"],"members":[{"depth":0,"name":"All Fix Versions","full_name":"[Fix Version].[All Fix Versions]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Open Library","full_name":"[Fix Version].[Open Library]","drillable":true,"key":"OL","expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[All Fix Versions]"},{"depth":2,"name":"Released","full_name":"[Fix Version].[Open Library].[Released]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[Open Library]"},{"depth":3,"name":"Version 1.0","full_name":"[Fix Version].[Open Library].[Released].[Version 1.0]","url_id":11400,"parent_key":"OL","parent_full_name":"[Fix Version].[Open Library].[Released]"},{"depth":2,"name":"Unreleased","full_name":"[Fix Version].[Open Library].[Unreleased]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[Open Library]"},{"depth":3,"name":"Version 2.0","full_name":"[Fix Version].[Open Library].[Unreleased].[Version 2.0]","url_id":11401,"parent_key":"OL","parent_full_name":"[Fix Version].[Open Library].[Unreleased]"}],"bookmarked_members":[],"current_page_members":["[Fix Version].[Open Library].[Released].[Version 1.0]","[Fix Version].[Open Library].[Unreleased].[Version 2.0]"]},{"name":"Issue Type","selected_set":["[Issue Type].[All Issue Types]"],"members":[{"depth":0,"name":"All Issue Types","full_name":"[Issue Type].[All Issue Types]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[All Issue Types]"]},{"name":"Time","selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time].[All Times]"]}]},"options":{"nonempty":"rows"},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Tempo planned hours":{"type":"column","dataLabelType":"top horizontal"},"Hours spent":{"type":"column","color":"#9043C2","dataLabelType":"top horizontal"}}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": []
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Project Flow Burn-Up Chart",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Hours spent cumulative]","[Measures].[Hours spent]","[Measures].[Total planned hours]","[Measures].[Cumulative Tempo planned hours]","[Measures].[Current period]"],"members":[{"depth":0,"full_name":"[Measures].[Hours spent cumulative]","format_string":"#,##0.00","report_specific":true,"name":"Hours spent cumulative","calculated":true},{"depth":0,"full_name":"[Measures].[Total planned hours]","format_string":"#,##0.00","report_specific":true,"name":"Total planned hours","calculated":true},{"depth":0,"name":"Cumulative Tempo planned hours","full_name":"[Measures].[Cumulative Tempo planned hours]","drillable":false,"calculation_of":"[Measures].[Tempo planned hours]","calculation":"cumulative_sum","format_string":"#,##0.00"},{"depth":0,"full_name":"[Measures].[Current period]","format_string":"","report_specific":true,"name":"Current period","calculated":true,"id":"[Measures].[Current period]"}]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Week].Members"],"members":[],"bookmarked_members":[]}],"filter_by":{"conditions":[{"expression":["[Measures].[Tempo planned hours]"],"operator":"\u003e","value":"0"}]}},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Hours budget control":{"type":"line","color":"#D4153B","symbol":false},"Hours spent":{"color":"#376BB7"},"Total planned hours":{"type":"line-Dash","symbol":false},"Tempo planned hours":{"type":"line"},"Cumulative Hours spent":{"color":"#B3D4FF"},"Cumulative Tempo planned hours":{"color":"#9043C2","type":"line"},"Current week":{"type":"plotline","dataLabelType":"top vertical"},"Current period":{"type":"plotline","dataLabelType":"top vertical"},"Hours spent cumulative":{"type":"area","color":"#7CA7E5"}}},"table":{}},"calculated_members":[{"dimension":"Measures","name":"Total planned hours","formula":"([Measures].[Tempo planned hours],\n[Time].CurrentHierarchy.DefaultMember)","format_string":""},{"dimension":"Measures","name":"Current period","formula":"CASE WHEN\nDateInPeriod(Now(),[Time].CurrentHierarchyMember)\nTHEN\n\"Current period\"\nEND","format_string":""},{"dimension":"Measures","name":"Hours spent cumulative","formula":"CASE WHEN\nDateAfterPeriodEnd(Now(),\n[Time].CurrentHierarchyMember.PrevMember)\nTHEN\nSum(\n {PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember},\n [Measures].[Hours spent]\n)\nEND","format_string":""}]}
} ],
"calculated_members": []
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Weekly Hours Spent by Issue Type",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Issue Type","selected_set":["[Issue Type].[Issue Type].Members"],"members":[],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Week].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[]},"options":{"nonempty":true},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": []
}

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Planned vs Spent Hours by Issue Resolution",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Resolution","selected_set":["[Resolution].[Resolution].Members"],"members":[],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Issue","selected_set":["[Issue].[Issue].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]","[Time].[Current month]"],"members":[{"depth":0,"name":"Current month","full_name":"[Time].[Current month]","annotations":{"group":"Default","predefined":"true"},"calculated":true,"drillable":true,"dimension":"Time"}],"bookmarked_members":[],"current_page_members":["[Time].[Current month]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Current month","format_string":"","formula":"Aggregate({\n [Time].[Month].CurrentDateMember\n})"}]
}