Create a % Complete report

[briantaylor]

I am trying to create a report that contains a count of issues in status but also want to total the issues and get a % of issue completed vs. Open

I can get a count in status but need a way to get the total and %

Sample Rreport

The report I have so far

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Security Scorecard”,
“folder_name”: “Test”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Issues created]"],“members”:[]},{“name”:“Status”,“selected_set”:["[Status].[Done]","[Status].[Blocked]","[Status].[Development]","[Status].[Open]"],“members”:[],“bookmarked_members”:[{“depth”:1,“name”:“Blocked”,“full_name”:"[Status].[Blocked]"},{“depth”:1,“name”:“Development”,“full_name”:"[Status].[Development]"},{“depth”:1,“name”:“Done”,“full_name”:"[Status].[Done]"},{“depth”:1,“name”:“Open”,“full_name”:"[Status].[Open]"}]}]},“rows”:{“dimensions”:[{“name”:“Team”,“selected_set”:["[Team].[All Teams]"],“members”:[{“depth”:0,“name”:“All Teams”,“full_name”:"[Team].[All Teams]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false,“removed”:true}],“bookmarked_members”:[]}]},“pages”:{“dimensions”:[]},“options”:{“nonempty”:“rows”,“total”:“columns”},“view”:{“current”:“table”,“maximized”:false,“table”:{}}}
} ],
“calculated_members”: []
}

[lauma.cirule]

Hi @briantaylor,

You can use tuples for the % of total calculations. Here is an example of a formula that would calculate how big percentage of all issues are in Done status:

CASE WHEN [Status].CurrentMember IS [Status].DefaultMember
THEN
  ([Measures].[Issues created], [Status].[Done]) /
  ([Measures].[Issues created], [Status].DefaultMember)
END

The CASE specifies to show this only when All Statuses level is selected so you can use the All statuses to see totals, see the example

Lauma / support@eazybi.com