Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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
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
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
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
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