Box-plot graphs

[Giovani]

I am trying to make a 2 box plot graphs and use some filters on that:

The data looks like this:

ID	Result	Result-Value
1	Negative	37
1	Inconclusive	34
1	Positive	9
1	Suspect	26
1	Positive	23
2	Positive	26
2	Positive	13
2	Negative	40
2	Negative	37
3	Negative	40
3	Suspect	35
3	Negative	37
4	Positive	22
4	Positive	21
4	Positive	16
5	Negative	37
5	Negative	37
5	Negative	37
5	Suspect	35
5	Negative	37
5	Negative	37

The graphs that I am trying to build are: 

1-Box-plot for all different results; 

2-Box-plot for all the results but considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive. Where only will cont once per ID. 

Any idea how can I build then?

[v-yulgu-msft]

Hi @Giovani,

Are you talking about custom visual 'Box and Whisker chart'? 

To show all different results in this visual, you only need to drag [ID] to Category section, [Result] into Sampling section and drag [Result-Value] into Values section.

I cannot understand what you said that 'considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive'. How to calculate the count for each ID? Could you provide more description about your requirement? It would be better you can post an image to show us your desired output.

Best regards,
Yuliana Gu

 

[Giovani]

Hi Yuliana,

Yes, I am talking about 'Box and Whisker chart'.

I tried to follow your steps but didn`t get the results.

I am going to update my database including another column with the date. 

ID	Result	Result-Value	Date
1	Negative	37	1/1/17
1	Inconclusive	34	1/1/17
1	Positive	9	1/1/17
1	Suspect	26	1/1/17
1	Positive	23	1/1/17
2	Positive	26	2/2/17
2	Positive	13	2/2/17
2	Negative	40	2/2/17
2	Negative	37	2/2/17
3	Negative	40	4/2/17
3	Suspect	35	4/2/17
3	Negative	37	4/2/17
4	Positive	22	4/3/17
4	Positive	21	4/3/17
4	Positive	16	4/3/17
5	Negative	37	6/17/17
5	Negative	37	6/17/17
5	Negative	37	6/17/17
5	Suspect	35	6/17/17
5	Negative	37	6/17/17

For the first steps, I am looking to build a 'Box and Whisker chart'  only with positive results in y-axis. I don`t want to compute together the results that are negative, suspect and or inconclusive. 

In the x-axis, I am looking to insert a timeline with each month of the year to compare the results year around.

Please, let me know if now it is more clear the result that I am looking for.

Thanks.

[v-yulgu-msft]

Hi @Giovani,

First, create a Month column in source table.

Month = Sheet1[Date].[Month]

To show all results in chart visual, please see below image.

If you only want to display positive results, you can set a visual level filter like below:

Best regards,
Yuliana Gu

[Giovani]

I am trying to make a 2 box plot graphs and use some filters on that:

The data looks like this:

ID	Result	Result-Value
1	Negative	37
1	Inconclusive	34
1	Positive	9
1	Suspect	26
1	Positive	23
2	Positive	26
2	Positive	13
2	Negative	40
2	Negative	37
3	Negative	40
3	Suspect	35
3	Negative	37
4	Positive	22
4	Positive	21
4	Positive	16
5	Negative	37
5	Negative	37
5	Negative	37
5	Suspect	35
5	Negative	37
5	Negative	37

The graphs that I am trying to build are: 

1-Box-plot for all different results; 

2-Box-plot for all the results but considering that in each ID only can count on time and the criteria for the count is negative > suspect> inconclusive > positive. Where only will cont once per ID. 

Any idea how can I build then?