Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have one requirement, in which i am displaying stacked bar chart for 2 dimensions. Now user wants to add Line to show the trend of same data. How should we achieve ?
Attached the expected output
USe combo chart..
Regards
Hi,
In expression tab add 1 expression > Select Display Option > Bar
In expression tab add 2 expression > Select Display Option > Bar
In Style > SubType > select stack.
In expression tab add 3 expression > Select Display Option > Line
Regards
I have 2 dimensions & single expression to be used
Below is the sample data. Using Month & Priority as dimension & Value in expression. Priority values are not fixed, so cann't hard code the expression as well.
Month | Priority | |
Feb-16 | Low | 28 |
Mar-16 | High | 1 |
Mar-16 | Low | 33 |
Apr-16 | Low | 16 |
May-16 | Low | 16 |
Jun-16 | Medium | 1 |
Jun-16 | Low | 18 |
Jul-16 | Low | 7 |
Manoj, Can i know what is your Dimensions and can you please share me the Sample App which demonstrates to understand the problem. Here, The best way to achieve is Combo Chart only. If your dimensions are Month and Priority what is the expression you are trying to show
What exactly your Req?
My Dimensions will be MonthYear & Priority, expression will be sum of Values.
Would like to see Stacked bar chart per month and along with the bars there should be a line to show the trend. Trend line is nothing but the total value of the corresponding month.
Hi Manoj
is the attached what you are looking for?
Dan
Hi Manoj
You need to create 3 bar expressions for priorities using set analysis and one line expression for total value.
See attached for details
Regards, VJ
Hi Manoj, one option is overlapping two charts:
- One for stacked bars in upper layer to make selections. Transparent background (in color tab). Using CTRL+MAYS to fix the legend area so it doesnt' moves.
- The 2nd with the trend line in a lower layer, removing axes, legends and everything else and place it where it fits with the chart area of the upper chart.
It's supposed that two charts will have the same axis values, if not you'll need to fix them using the max and min in the axis tab to keep the same range in both charts.