Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
One chart is having 2 dimension values and 2 expressions i want to show these values in combo chart. Its working fine for 1 dimension and 2 expressions, but if i added 2nd dimension to same chart then dimensions are over lopping each other and i have more number of dimensins also,after selecting stacked option from chart properties also its not working. So please help how to resolve this issue..
Hi Anil,
Can you attach sample file.
Regards,
Jagan.
Hi Jagan, am not able to up load the sample file i am just attaching the sample screen shot of that combo chart , in below chart 2 dimension (Loc) would be as stacked but the stacked option is disbaled here, how to do that here.
please use this as sample data ,, Manager, Loc are the 2 dimensions and Appl,DB are 2 expressions... i think this may give you a idea....
LOAD * INLINE [
Manager, Appl, DB, Loc
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, ABC
HONNILA, AMPS Assembly, Oracle, DEF
HONNILA, AMPS Assembly, Oracle, DEF
MICHAEL, Dealer Business Management, DB2, DEF
MICHAEL, Dealer Business Management, DB2, DEF
MICHAEL, Dealer Business Management, DB2, GHI
MICHAEL, Dealer Business Management, DB2, GHI
ANTHONY, Capacity and Option Planning System, Sybase, GHI
ANTHONY, Capacity and Option Planning System, Sybase, XYZ
ANTHONY, Capacity and Option Planning System, Sybase, XYZ
DAVID, Collaboration Database, Gateway , XYZ
DAVID, Collaboration Database, Gateway , XYZ
];
Hi Anil,
Please find the attachment. Hope this helps you.
Regards,
Jagan.
Jagan thnx for replay, In bar chart if we have two dimenisons one expression we can apply the stacked option. My req is i have 2 dimensions and 2 expressions for this i want to use combo chart with stacked option as per my customer req how can we do this.
In our above example inline table is having 4 mangaers but in above chart we can see 2 managers only and either of the dimension should be stacked. Below is the chart for 2 dimensions and 1 expression from this same chart i want to add one more expression like count(Appl) and either of the dimension should be stacked like below screenn shot...
Hi,
I tried it, but when we add the second expression the chart is not working correctly as expected. Try adding second expression and group the two expressions, in that way you can toggle between the two expressions. In one chart it is not rendering correctly.
Regards,
Jagan.