All eazyBI for Jira eazyBI for Confluence Private eazyBI
All eazyBI for Jira eazyBI for Confluence Private eazyBI

Tempo Planner Report Examples
eazyBI for Jira

The following report examples are based on Tempo Planner integration. To copy these reports to your own eazyBI accounts to use with your Tempo data, see how to export and import report definitions.

Team Hours Weekly Accountability Report

{
"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"}]
}


Tempo Hours Planned vs Hours Spent

{
"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})"}]
}


Gantt Chart for Project Planning & Progress

{
"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": []
}


Planned Assigned Hours vs Contribution

{
"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": []
}


Project Flow Burn-Up Chart

{
"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": []
}



Weekly Hours Spent by Issue Type

{
"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": []
}


Planned vs Spent Hours by Issue Resolution

{
"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})"}]
}