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

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:

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:

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:

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:

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:

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:

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:

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