
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bar chart - divide each bar into stacks
Hi, I have this bar/line graph:
dimension -> year
bars:
expression -> counts for A, B, C, D
lines:
expression-> rates for A, B, c, D
I want to stack the bars A, B, C, D into A->x1+x2+x3, B->x1+x2+x3, c->x1+x2+x3
X-> x1,x2,x3 is another dimension, I want to break the count of A, by sub groups of dimension X.
I want to stack count({x=x1}A), count({x=x2}A), count({x=x3}A) into count(A)
Is this possible?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share sample data and expected output, if I understand correctly you want to stack your count value bars for your second dimension. Sample data and image of expected output with reference to your data will help to understand better.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try these? If not can you share a sample app?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
below is the sample data. I am not able to attaché the app.
year | group | subgroup | accs | bad |
2012 | A | x1 | 10 | 1 |
2012 | A | x2 | 20 | 3 |
2012 | A | x3 | 30 | 3 |
2012 | B | x1 | 40 | 7 |
2012 | B | x2 | 50 | 7 |
2012 | B | x3 | 60 | 9 |
2012 | C | x1 | 70 | 5 |
2012 | C | x2 | 80 | 8 |
2012 | C | x3 | 90 | 2 |
2012 | D | x1 | 100 | 4 |
2012 | D | x2 | 110 | 11 |
2012 | D | x3 | 120 | 8 |
2013 | A | x1 | 130 | 9 |
2013 | A | x2 | 140 | 4 |
2013 | A | x3 | 150 | 3 |
2013 | B | x1 | 160 | 16 |
2013 | B | x2 | 170 | 12 |
2013 | B | x3 | 180 | 18 |
2013 | C | x1 | 190 | 11 |
2013 | C | x2 | 200 | 54 |
2013 | C | x3 | 210 | 45 |
2013 | D | x1 | 220 | 8 |
2013 | D | x2 | 230 | 23 |
2013 | D | x3 | 240 | 4 |
2014 | A | x1 | 250 | 67 |
2014 | A | x2 | 260 | 26 |
2014 | A | x3 | 270 | 34 |
2014 | B | x1 | 280 | 28 |
2014 | B | x2 | 290 | 65 |
2014 | B | x3 | 300 | 30 |
2014 | C | x1 | 310 | 67 |
2014 | C | x2 | 320 | 32 |
2014 | C | x3 | 330 | 88 |
2014 | D | x1 | 340 | 34 |
2014 | D | x2 | 350 | 35 |
2014 | D | x3 | 360 | 36 |
2015 | A | x1 | 370 | 87 |
2015 | A | x2 | 380 | 38 |
2015 | A | x3 | 390 | 39 |
2015 | B | x1 | 400 | 40 |
2015 | B | x2 | 410 | 47 |
2015 | B | x3 | 420 | 54 |
2015 | C | x1 | 430 | 89 |
2015 | C | x2 | 440 | 44 |
2015 | C | x3 | 450 | 56 |
2015 | D | x1 | 460 | 46 |
2015 | D | x2 | 470 | 47 |
2015 | D | x3 | 480 | 48 |
