chart with Quarter year filed

[prma7799]

Hi All,

I have one requirement that i need quateryear field(Q1 15 Q2 15 Q3 15.....ETC ) in chart for all years and the this year sale with growth line...

Can you please help me out.

PFA

Thanks

[avinashelite]

you have already implemented Quarter Year rite?

If your looking for the Liner growth line ? then you can check the Liner option in the expression

[prma7799]

Yes..

But when i applied pivot table expression in bar chart the values is not coming proper.

Please can you help me to achieve  this .

PFA...

[prma7799]

Hi All, gwassenaar‌, sunindia‌ jagan‌,

Any help on this?

[avinashelite]

Problem is with the Growth calculation , what is the requirement here ? a easy fix would be check of the current year condition in the dimension itself that would help

[prma7799]

Hi Avinash,

The growth formula is right as you see the pivot table am taking that only.

I want chart like below...

See the red and blue mark I and my team achieve the two axis but didn't get growth bar like below...

Thanks

[avinashelite]

yes, I got your point the problem is your trying to get the chart data for the current year and the growth rate is calculated over the time that's why it not getting populated properly , once i get time will try to tweak your expression

[prma7799]

Hi Avinash,

For time-being give some alternate solution because it is urgent requirement for our client. 

All we are stuck with this....

And please if you get free time then please look into this.

Thanks in Advance.

[avinashelite]

Hi ,

I got the problem

In the pivot table your not considering the year hence its calculating the values based on the quarter , if you convert the bar chart with only Quarter values it will surely work fine . if you need to include the year than , you need to calculate the rolling month values in the script level and then you need make use the same in front end. Check this article

Calculating rolling n-period totals, averages or other aggregations 

[prma7799]

Yes...

You are right but our requirement is to show at least three year data with all quarter like below

If i am taking only quarter then it will show me only two for 2015-16 and four for 2014-15