Visualisation from 2 diffrent queries

[Anonymous]

Hello all,  I really do hope I will explain this as well as possible.

What I need is a graph that represtens the ratio of successful sprints to the number of sprints for a team of developers.

So a simple graph where two measurements are taken. But here where the problem lays I'd say. I've got the data in 2 diffrent Queries. 

So the number of sprints is taken from a diffrent table that looks like this (and is taken from a summary tab)

Team	Quarter	Number of sprints
Team1	Q1	5
Team2	Q1	5
Team3	Q1	4
Team4	Q1	4
Team1	Q2	6
Team2	Q2	7
Team3	Q2	9
Team4	Q2	8
Team1	Q3	4
Team2	Q3	6
Team3	Q3	8
Team4	Q3	5
Team1	Q4	1
Team2	Q4	6
Team3	Q4	5
Team4	Q4	7

as where the the sprint success count FOR TEAM 1 is taken from a table that looks like this :

Sprint #	Quarter	Sprint successful
1	Q1	1
2	Q1	1
3	Q1	0
4	Q1	1
5	Q1	0
6	Q2	1
7	Q2	1
8	Q2	1
9	Q2	1
10	Q2	1
11	Q2	1
12	Q3	1
13	Q3	1
14	Q3	1
15	Q3	1
16	Q4	1

So if the sprint was succsessful we've got 1 if not then 0. I'm trying my best to achieve this but it's not working. It either sums up all the data for the whole year. Or by some weird reason show for each quareter exactly the same data. Does anyone have any suggestion how could this be resolved?

If anything is unclear please let me know I'll be glad to explain !

[v-danhe-msft]

Hi @Anonymous,

From your description, could you mean [Sprint successful] is your desired column? If so, how could you define "So if the sprint was succsessful we've got 1 if not then 0"? Could you please offer me more information or pbix file to haev a test if possible?

Regards,

Daniel He

[Anonymous]

Hi, thanks for the reponse!! Let me explain because I might have been to chaotic, all the information are based in an excell file. Where the first tab is a summary tab and as you can see on the left the information is sumed up for each quarter. 

1. On the left is the tab where we've got summary tab with all the teams. And I would like to show that as the black column in the visualisation. 

2. On the right is the view of the team where if a sprint was successfull they'd add 1 if not then 0. And I would like THE SUM of each quarter to be shown as the blue column in the visualistaion?

Unfortunately I can't share the pbix. 

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you could refer to below steps:

Create relationships between two quarters:

Use related fields to make your desired visual:

You could also download the pbix file to have a view.

Regards,

Daniel He