sql server 2008 – Overlapping Scatter Plots Graphs Different Parent Group – SSRS Visual Studio

0
6

Utilizing Visual Studio reporting tool I need to create a scatter plot graph in a Tablix that contains the data for each ‘ID’ from a ‘Section’ group (detail graph). I need this to lay on top of a summary graph that shows scores for all ‘ID’s’ within the ‘Section’ instead of individually for a comparison. I’m currently able to have a summary chart after all of the individual charts however I am unable to get them to overlap due to the different groupings that are needed (Detail is grouped by Section->ID, Summary is grouped only by Section). Any help or ideas would be greatly appreciated (data in image is not the same a below).

Section | ID | scoreOne | scoreTwo                                                      
   1    |  1 |    5     |    2                                              
   1    |  2 |    3     |    5                                                         
   1    |  3 |    3     |    4                                                                           
   1    |  4 |    4     |    4                                                                           
   1    |  5 |    4     |    3                                                                            
   1    |  6 |    1     |    3                               
   1    |  7 |    3     |    3                                                                                                             
   1    |  8 |    4     |    2  

Scatter Plot Detail and Summary example

LEAVE A REPLY

Please enter your comment!
Please enter your name here