2 Replies Latest reply: Apr 10, 2017 9:18 AM by Celine Xu RSS

    Create multiple lines in one line chart (not column ) and drill down function

    Celine Xu

      Hi, here is the data set

       

      1. wondering could I create a line chart, having Month as dimension. but Segment or Prod_type as each line (only choose one each time)

      say. . dimension:  Month

                having 8 lines: for 8 Segment: MNC, SME.... have Sum(CLS_STK) as measure?  (need to aggregate there are several MNC for each month)

                and have 8 lines have different color

       

      how could I do that?

       

      then if use

             dimension:  Month

            each product type as each line

       

      How could I do that?

       

       

      2. when we talk to drill down, could we also create a drill down for this sheet?

      say, the product_type is the first level and the Segment is the second level`? if we can how could we do that?

       

      or we can not create a drill down function, because each product have same 8 segement tagw, so we can only use filter function?

       

      3. could I also create a combom chart having

      Month as Dimension

      have only Fix broadband as object (do not need to show other product time)

      Sum of Sum(CLS_STK) as the measure(the bar)  and the point for each month is  average of Sum(AVTN_CNT)

       

       

      Thank you so much!!

        • Re: Create multiple lines in one line chart (not column ) and drill down function
          omar bensalem

          For creating Drill down dimensions:

          Capture.PNG

          Then use it s a dimension in a graphic:

          Capture.PNG

           

          Capture.PNG

           

          For your first question, create a table inline as follow:

          load * Inline [

          DimId, Dim

          1, Segment

          2, ProdType

          ];

           

          Then create a variable named vDim for example : if(DimId=1,Segment,Prod_type)

          Capture.PNG

           

          Then select a line chart, as dimension 1 : Month

          As dimension 2: call you variable that depends on the selection of segment or prodType (the 2 fields we created with the inline table): $(vDim)

          and your measure:

           

          See the attached app:

            • Re: Create multiple lines in one line chart (not column ) and drill down function
              Celine Xu

              Thank you so much. But if could have more info about the second halve will be good.

              so 1. I need to go to data loading manager create a table by using this sentence>

              load * Inline [

              DimId, Dim

              1, Segment

              2, ProdType

              ];

               

              2.Then I go back to app, create the vDim variable

               

              then 3. create the line chart 

              dimension 1: Month

              dimension 2:  $(vDim)

              (exacty the same typing?)

              or?

               

              Thank you.

               

              I  tried out the simple way, just add 2 dimensions in the line chart.

              create 2 graphs.

              Graph 1: 1. month 2. Segment

              Graph 2: 1 month 2. prod_type

               

              seems work. Do you think that is fine? Thank you!