5 Replies Latest reply: Dec 20, 2011 8:30 AM by jagan mohan rao appala RSS

    combo chart issue

      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.. 

        • combo chart issue
          jagan mohan rao appala

          Hi Anil,

           

          Can you attach sample file.

           

          Regards,

          Jagan.

            • combo chart issue

              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

              ];

               

              1234.JPG

            • Re: combo chart issue
              jagan mohan rao appala

              Hi Anil,

               

              Please find the attachment. Hope this helps you.

               

              Regards,

              Jagan.

                • combo chart issue

                  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...

                   

                  test2.JPG

                    • combo chart issue
                      jagan mohan rao appala

                      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.