Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scenario where i have month on month sales available with me.
Month Sales Growth
Dec'13 40
Jan'14 55 15
Feb'14 60 5
Mar'14 65 5
Apr'14 70 5
Now if i select a time period "YTD" on my dashboard the data fetched will be
Month Sales Growth
Jan'14 55 15
Feb'14 60 5
Mar'14 65 5
Apr'14 70 5
I have to calculate the growth and represent the same as line chart
Abhishek,
If you have the data and the growth, just add the expression for growth in the expressions tab
=sum(Growth)
Please, elaborate further your requirement.
Marc.
I don't have growth... I need to calculate it and then create a chart of growth
ok. One way to do it is: having the expression of Sales, add another one, equals to first, and select accumulate 1 step back and select invisible. Add a third expression =expression2-expression1.
Marc.
Hi,
Lets try this
In line chart write this in the Exppression tab.hope this will work
Sum({YTD={1}>} Growth)
Can you please help me with an example?