7 Replies Latest reply: Mar 18, 2013 8:40 AM by Chenna Reddy RSS

    moving annual, year to date, last 6months, 3months, monthly on same graph

      Hi there,

       

      I'm trying to replicate this graph but its proving tricky. Does anyone have an example of how to do this?

       

      The graph shows Market Growth vs Product Growth and product share

       

      Thanks,

        • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

          Hi,

           

          Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

           

          Create an inline function with the same fields as above and do not link to any other table.

          eg:

           

          Load * Inline [

          ID,Value

          1, Moving Annual

          2, Year To Date

          3, Last 6 Months ];

           

          Use the inline fields as dimension eg: Value fields in dimension

          In expression by giving each condition evaluating with Inline value field you have to write expression

           

          eg:

           

          if(ID=1,sum(Moving Annual)

          if(ID=2, sum(Year To Date)))

           

          etc...

           

          Hope it helps for your query.

           

          Chenna

          • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

            Hi,

             

            Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

             

            Create an inline function with the same fields as above and do not link to any other table.

            eg:

             

            Load * Inline [

            ID,Value

            1, Moving Annual

            2, Year To Date

            3, Last 6 Months ];

             

            Use the inline fields as dimension eg: Value fields in dimension

            In expression by giving each condition evaluating with Inline value field you have to write expression

             

            eg:

             

            if(ID=1,sum(Moving Annual)

            if(ID=2, sum(Year To Date)))

             

            etc...

             

            Hope it helps for your query.

             

            Chenna

            • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

              Hi,

               

              Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

               

              Create an inline function with the same fields as above and do not link to any other table.

              eg:

               

              Load * Inline [

              ID,Value

              1, Moving Annual

              2, Year To Date

              3, Last 6 Months ];

               

              Use the inline fields as dimension eg: Value fields in dimension

              In expression by giving each condition evaluating with Inline value field you have to write expression

               

              eg:

               

              if(ID=1,sum(Moving Annual)

              if(ID=2, sum(Year To Date)))

               

              etc...

               

              Hope it helps for your query.

               

              Chenna

              • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

                Hi,

                 

                Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

                 

                Create an inline function with the same fields as above and do not link to any other table.

                eg:

                 

                Load * Inline [

                ID,Value

                1, Moving Annual

                2, Year To Date

                3, Last 6 Months ];

                 

                Use the inline fields as dimension eg: Value fields in dimension

                In expression by giving each condition evaluating with Inline value field you have to write expression

                 

                eg:

                 

                if(ID=1,sum(Moving Annual)

                if(ID=2, sum(Year To Date)))

                 

                etc...

                 

                Hope it helps for your query.

                 

                Chenna

                • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

                  Hi,

                   

                  Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

                   

                  Create an inline function with the same fields as above and do not link to any other table.

                  eg:

                   

                  Load * Inline [

                  ID,Value

                  1, Moving Annual

                  2, Year To Date

                  3, Last 6 Months ];

                   

                  Use the inline fields as dimension eg: Value fields in dimension

                  In expression by giving each condition evaluating with Inline value field you have to write expression

                   

                  eg:

                   

                  if(ID=1,sum(Moving Annual)

                  if(ID=2, sum(Year To Date)))

                   

                  etc...

                   

                  Hope it helps for your query.

                   

                  Chenna

                  • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

                    Hi,

                     

                    Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

                     

                    Create an inline function with the same fields as above and do not link to any other table.

                    eg:

                     

                    Load * Inline [

                    ID,Value

                    1, Moving Annual

                    2, Year To Date

                    3, Last 6 Months ];

                     

                    Use the inline fields as dimension eg: Value fields in dimension

                    In expression by giving each condition evaluating with Inline value field you have to write expression

                     

                    eg:

                     

                    if(ID=1,sum(Moving Annual)

                    if(ID=2, sum(Year To Date)))

                     

                    etc...

                     

                    Hope it helps for your query.

                     

                    Chenna

                    • Re: moving annual, year to date, last 6months, 3months, monthly on same graph

                      Hi,

                       

                      Firstly Create the flags for Moving annual, Year to Date, Last 6 Months and 3Months in Script calendar as per the perdiods with the flag as 1 or 0.

                       

                      Create an inline function with the same fields as above and do not link to any other table.

                      eg:

                       

                      Load * Inline [

                      ID,Value

                      1, Moving Annual

                      2, Year To Date

                      3, Last 6 Months ];

                       

                      Use the inline fields as dimension eg: Value fields in dimension

                      In expression by giving each condition evaluating with Inline value field you have to write expression

                       

                      eg:

                       

                      if(ID=1,sum(Moving Annual)

                      if(ID=2, sum(Year To Date)))

                       

                      etc...

                       

                      Hope it helps for your query.

                       

                      Chenna