0

I have a chart in SSRS where I use data from two different datasets. Currently I have 2 values from dataset 1 and 2 values from dataset 2 but they are all grouped up into 1 category. Is there a way to group the data by datasets so I can display the data seperately?

Below is the table. The first row is data set 1 and the second row is data set 2 Table

This is the chart I already have. I want to bring the dataset 2 values 3.45% and 29.27% in its own group and separate it from dataset 1 data on the same axis.

Chart

TheProgrammer
  • 1,314
  • 5
  • 22
  • 44

1 Answers1

1

You will see some visual differences because I'm using 2016, but the theory of the chart building is the same.

[SQL Query]

1[Chart]2

Can you confirm if this is the chart that you are trying to build?

Here is a picture of how I setup the chart properties:

Chart properties

Daniel
  • 1,364
  • 1
  • 19
  • 34
  • Yes that is the chart im trying to build – TheProgrammer Jun 09 '17 at 17:09
  • 1
    Okay, well your query will be more complicated than my simple SELECTs, but the concept is the same. Add a static column to each side of the UNION and do a "Series Group" on that static value. Hopefully that gets you down the right path. – Daniel Jun 09 '17 at 17:10
  • One small thing that is off in my situation, The first row in the data should be dataset1 h54rh0001 .61(under participation), .29(under column improvment). Next row: dataset2 flex .08(under participation), .03(under column improvement) – TheProgrammer Jun 09 '17 at 18:09
  • Also it is summing 29.47 and 2.45% – TheProgrammer Jun 09 '17 at 18:42