Hi! I’m new to easy BI and am having issues creating a chart. I would like to add a bug count line on top of my velocity chart to correlate number of bugs in the sprint to lower story point completion. We do not size bugs, so I would like to show a count.
here is what I have so far
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Sprint Story Points Completed versus bug count",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Sprint issues at closing]","[Measures].[Sprint Story Points completed]"],"members":[]},{"name":"Issue Type","selected_set":["[Issue Type].[Bug]","[Issue Type].[Story]","[Issue Type].[Task]"],"selected_set_action":[],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Sprint","selected_set":["[Sprint.By status].[Closed].[GSE board].[Sprint 82]","[Sprint.By status].[Closed].[GSE board].[Sprint 83]","[Sprint.By status].[Closed].[GSE board].[Sprint 84]","[Sprint.By status].[Closed].[GSE board].[Sprint 85]","[Sprint.By status].[Closed].[GSE board].[Sprint 86]","[Sprint.By status].[Closed].[GSE board].[Sprint 87]","[Sprint.By status].[Closed].[GSE board].[Sprint 88]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Sprint.By status].[Sprint])","members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Sprint","duplicate":true,"selected_set":["[Sprint.By status].[Closed]"],"members":[{"depth":1,"name":"Closed","full_name":"[Sprint.By status].[Closed]","drillable":true,"expanded":true,"drilled_into":false},{"depth":2,"name":"GSE board","full_name":"[Sprint.By status].[Closed].[GSE board]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Sprint.By status].[Closed]"},{"depth":3,"name":"Sprint 82","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 82]","url_id":195,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 83","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 83]","url_id":196,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 84","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 84]","url_id":197,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 85","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 85]","url_id":198,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 86","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 86]","url_id":199,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 87","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 87]","url_id":200,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"},{"depth":3,"name":"Sprint 88","full_name":"[Sprint.By status].[Closed].[GSE board].[Sprint 88]","url_id":201,"url_sub_id":5,"parent_full_name":"[Sprint.By status].[Closed].[GSE board]"}],"bookmarked_members":[],"current_page_members":["[Sprint.By status].[Closed].[GSE board].[Sprint 82]","[Sprint.By status].[Closed].[GSE board].[Sprint 83]","[Sprint.By status].[Closed].[GSE board].[Sprint 84]","[Sprint.By status].[Closed].[GSE board].[Sprint 85]","[Sprint.By status].[Closed].[GSE board].[Sprint 86]","[Sprint.By status].[Closed].[GSE board].[Sprint 87]","[Sprint.By status].[Closed].[GSE board].[Sprint 88]"]},{"name":"Status","selected_set":["[Status.Category].[All Statuses by category]"],"members":[{"depth":0,"name":"All Statuses by category","full_name":"[Status.Category].[All Statuses by category]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"To Do","full_name":"[Status.Category].[To Do]","drillable":true,"expanded":false,"drilled_into":false,"parent_full_name":"[Status.Category].[All Statuses by category]"},{"depth":1,"name":"In Progress","full_name":"[Status.Category].[In Progress]","drillable":true,"parent_full_name":"[Status.Category].[All Statuses by category]"},{"depth":1,"name":"Done","full_name":"[Status.Category].[Done]","drillable":true,"parent_full_name":"[Status.Category].[All Statuses by category]"}],"bookmarked_members":[],"current_page_members":["[Status.Category].[To Do]","[Status.Category].[In Progress]","[Status.Category].[Done]"]},{"name":"Issue Type","duplicate":true,"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","expanded":true,"drilled_into":false,"removed":true},{"depth":1,"name":"Bug","full_name":"[Issue Type].[Bug]","parent_full_name":"[Issue Type].[All Issue Types]"},{"depth":1,"name":"Story","full_name":"[Issue Type].[Story]","parent_full_name":"[Issue Type].[All Issue Types]"},{"depth":1,"name":"Task","full_name":"[Issue Type].[Task]","parent_full_name":"[Issue Type].[All Issue Types]"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Bug]","[Issue Type].[Story]","[Issue Type].[Task]"]}]},"options":{"nonempty":"rows"},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":true,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"To Do":{"color":"#344563"},"In Progress":{"color":"#2F579C"},"Done":{"color":"#00875A"},"In Acceptance Testing":{"color":"#9043C2"},"In Release Prep":{"color":"#FFBC29","type":"column"},"Not Started":{"color":"#5E6C84"},"In Development":{"color":"#2F579C"},"In QA":{"color":"#F95E16"},"Released":{"color":"#00875A"},"Not Started;Story":{"type":"line"},"Sprint Story Points completed;Bug":{"color":"#006644"},"Sprint Story Points completed;Story":{"color":"#006644"},"Sprint Story Points completed;Task":{"color":"#006644"},"Sprint issues at closing;Bug":{"type":"line"},"Sprint issues at closing;Story":{"separateAxis":1,"stacked":3,"type":"text","color":"#091E42"},"Sprint issues at closing;Task":{"color":"#091E42","type":"text"}}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"name":"Sprint Story Points at closing","dimension":"Measures","format_string":"#,##0.00","formula":"-- Story points from issues when a sprint was closed\n( [Measures].[Story Points added],\n [Transition Field].[Sprint status],\n [Sprint Status].[Closed],\n [Issue Sprint Status Change].[Active =\u003e Closed]\n)\n"},{"name":"Sprint Story Points completed","dimension":"Measures","format_string":"#,##0.00","formula":"(\n [Measures].[Sprint Story Points at closing],\n [Transition Status.Category].[Done]\n)\n"},{"name":"Sprint issues at closing","dimension":"Measures","format_string":"#,##0","formula":"( [Measures].[Transitions to],\n [Transition Field].[Sprint status],\n [Sprint Status].[Closed],\n -- An issue was in a sprint at closing\n [Issue Sprint Status Change].[Active =\u003e Closed]\n)\n"}]
}
which renders like this:
It’s a work around but janky and doesn’t show committed versus completed.
