Dear There,
We created a metric to collect the issue resolution data for different teams – total teams, and x team and y team etc.
We now want to calculate, the % of the (issue resolution data for x team) / (issue resolution data for total teams)
How shall we design the calculation? Is it a must to create a new measure? If yes how the calculation should be design…
This seems a bit complicated than I can design… Please kindly help. Thanks!
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “ThinOS SUS metric #999 team resolution total”,
“folder_name”: “Leon Kan Li (please do not edit)”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Time”,“selected_set”:["[Time].[Month].Members"],“members”:[{“depth”:3,“name”:“Jan 2019”,“full_name”:"[Time].[2019].[Q1 2019].[Jan 2019]",“drillable”:true,“removed”:true},{“depth”:3,“name”:“Nov 2018”,“full_name”:"[Time].[2018].[Q4 2018].[Nov 2018]",“drillable”:true,“removed”:true},{“depth”:3,“name”:“Dec 2018”,“full_name”:"[Time].[2018].[Q4 2018].[Dec 2018]",“drillable”:true,“removed”:true}],“bookmarked_members”:[]}]},“rows”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Total Engineers with resolution]","[Measures].[Issues resolved]","[Measures].[Total estimate hrs of resolution]"],“members”:[]},{“name”:“Engineer”,“selected_set”:["[Engineer].[All Engineers THINOS]","[Engineer].[>>> BJDC SUS]","[Engineer].[BJDC 100%]","[Engineer].[BDC 100%]","[Engineer].[SVDC 100%]","[Engineer].[NONE / OLD]"],“members”:[],“bookmarked_members”:[]}]},“pages”:{“dimensions”:[{“name”:“Project”,“selected_set”:["[Project].[Project].Members"],“members”:[{“depth”:1,“name”:“ThinOS Defect Management”,“full_name”:"[Project].[ThinOS Defect Management]",“drillable”:true,“key”:“THINOS”},{“depth”:1,“name”:“ThinOS Maintenance”,“full_name”:"[Project].[ThinOS Maintenance]",“drillable”:true,“key”:“THINOXSUS”}],“bookmarked_members”:[],“current_page_members”:["[Project].[ThinOS Defect Management]","[Project].[ThinOS Maintenance]"]},{“name”:“Found By”,“selected_set”:["[Found By].[All Found Bies]"],“members”:[{“depth”:0,“name”:“All Found Bies”,“full_name”:"[Found By].[All Found Bies]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:[],“current_page_members”:["[Found By].[All Found Bies]"]},{“name”:“Sub Project”,“selected_set”:["[Sub Project].[All Sub Projects]"],“members”:[{“depth”:0,“name”:“All Sub Projects”,“full_name”:"[Sub Project].[All Sub Projects]",“drillable”:true,“type”:“all”}],“bookmarked_members”:[],“current_page_members”:["[Sub Project].[All Sub Projects]"]}]},“options”:{“nonempty”:true},“view”:{“current”:“table”,“maximized”:false,“table”:{“freeze_header”:true}}}
} ],
“calculated_members”: [{“name”:“SVDC 100%”,“dimension”:“Engineer”,“formula”:“Aggregate({\n[Engineer].[Michael Chew], [Engineer].[Usman Ansari], \n[Engineer].[Yani Lau], [Engineer].[Bach Le],\n[Engineer].[Raghu Chereddy]\n\n})”,“format_string”:""},{“name”:“BDC 100%”,“dimension”:“Engineer”,“formula”:“Aggregate({\n[Engineer].[Ajit Kishore], [Engineer].[Dheeraj Reddy],\n[Engineer].[Anil Gurumurthy]\n\n})”,“format_string”:""},{“name”:">>> BJDC SUS",“dimension”:“Engineer”,“formula”:“Aggregate({\n[Engineer].[Daniel Liu], [Engineer].[Dawei Jiang] ,\n[Engineer].[Wei Zhao3] , [Engineer].[Jian Yu] ,\n[Engineer].[Jun Yuan1] , [Engineer].[Zhen Lei] ,\n[Engineer].[Xin Yao],\n[Engineer].[Pingyuan Teng],\n[Engineer].[Yinghui He],\n[Engineer].[Shaotian Yu],\n[Engineer].[Jacob Wang]\n})”,“format_string”:""},{“name”:“NONE / OLD”,“dimension”:“Engineer”,“formula”:"\nAggregate({\n\n[Engineer].[(none)]\n\n})\n\n",“format_string”:""},{“name”:“Total estimate hrs of resolution”,“dimension”:“Measures”,“formula”:“Sum(\n Filter(\n Descendants([Issue].CurrentMember,\n [Issue].[Issue]),\n [Measures].[Issues resolved]>0\n ),\n–[Issue].CurrentHierarchyMember.get(‘Original estimated hours’)\n\n [Measures].[Original estimated hours resolved]\n --(\n-- [Measures].[Original estimated hours]–,\n-- [Engineer].CurrentHierarchyMember,\n-- [Time].CurrentMember)\n)\n”,“format_string”:"#,##0.00"},{“name”:“Total Engineers with resolution”,“dimension”:“Measures”,“formula”:“case when [Measures].[Issues resolved]>0\nTHEN\nCount(\nFilter(\nGenerate(\n ChildrenSet([Engineer].CurrentHierarchyMember),\n Descendants([Engineer].CurrentHierarchyMember, [Engineer].[Engineer])\n ),\n(\n[Measures].[Issues resolved]\n–,--\n–[Status].CurrentHierarchy.DefaultMember–\n)>0\n)\n)\nEND”,“format_string”:""},{“name”:“BJDC 100%”,“dimension”:“Engineer”,“formula”:“Aggregate({\n[Engineer].[Daniel Liu], [Engineer].[Dawei Jiang] ,\n[Engineer].[Wei Zhao3] , [Engineer].[Jian Yu] ,\n[Engineer].[Xin Yao],\n[Engineer].[Pingyuan Teng],\n[Engineer].[Shaotian Yu],\n[Engineer].[Jacob Wang]\n})”,“format_string”:""}]
}