question

ktbma-0096 avatar image
0 Votes"
ktbma-0096 asked Joyzhao-MSFT edited

How to make chart display bars for different separated categories (group series)?

(This is the first time I post so I hope this is the right place for this post)

I need to create a dashboard with a bar chart for the sum of the different record types(A,B,C,...) by month.
So I have months as the X axis.
The sum is the number of cases as the Y values.
The problem is that for every individual record the types can be two or more as in (A,R).
So I thought of 2 different ways to hande it:

  1. Have one type column and separate the different values by a comma or semicolon.

  2. Or have another column for the types that can be found as a second valuesince there aren't many.


What I was wondering for number one is, is there a way to then separate the value with multiple types and somehow separate the types in a way that can be shown in the chart bar as 2 different bars? (ex: january we have one record of 2 types so I should have 2 bars of the same height)

If this isn't possible, I was thinking of the second option but when I put them both in the group series they both get mixed or concatenated (as we can see in the legend).

If both aren't plausible, could you suggest a solution that would allow me to get the wanted results

Thanks in advance!

EDIT: I don't know if I made things more complex than they are, but basically what I would want is to be able to have two group series independently shown on the graph like "Groupe1 value a Groupe1 value b Groupe2 value aa Groupe2 value bb..."

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered ktbma-0096 commented

Hi @ktbma-0096 ,
I am not sure if my understanding is correct. If you just want to display the different values of the two groups on the chart, you only need to add a grouping field on the "Series Group". If I misunderstand what you mean, please feel free to correct me.
91898-01.jpg
91899-02.jpg
To be honest, I suggest that you provide specific test data and the renderings you want, so that it is easy to resolve your issue.
Best Regard,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (50.8 KiB)
02.jpg (16.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,
For some reason, I couldn't comment your answer even if it was in the limit.
So I decided to submit an answer instead, waiting for it to be moderated.

0 Votes 0 ·
ktbma-0096 avatar image
0 Votes"
ktbma-0096 answered Joyzhao-MSFT edited

Hello @Joyzhao-MSFT
I actually already did this step; months and sum of values by category , maybe I was a bit vague in my post I tweaked it a bit but as you asked I'll give more details here:
An example of my data:
- for the first case is:
Id,month,year,....,Type
1,'february',2021,....,'C;D'
2,'march',2021,....,'X'
...
55,'december',2021,...,'X'
And what I want to show is a graph like this:
tst.jpg

So the values for the row with 1 as id is put in the graph as two records for C aswell as D.
I don't know if I'm making myself clear here, don't hesitate if there's still some things to adress.
-as for the second case:
This was considered in the case where the first option wasn't possible (because I don't know how doable it is to manipulate values)
so our data would be in this new case:
Id,month,year,....,Type,TypeX
1,'february',2021,....,'C','D'
2,'march',2021,....,'X',NULL
...
The problem is when you put 2 grp series they are not independent. How can I have the graph shown?


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I suggest you first learn about category groups and Series groups. According to my understanding, you want to display the month of 2020 and the month of 2021 in Category Groups, while the Series Groups display Type and TypeX. I think this is impossible to achieve in a bar chart. Nevertheless, I did the test locally and it was impossible to achieve as I said.

0 Votes 0 ·