Growth rate year over year in same graph

[ajinkyabhonsle]

Hi All,

I am looking to have a line chart to show growth rate fiscal year over fiscal year in the same graph(attached). So the idea is whenever  a user selected for example the fiscal month = September. The year over year should change for only September months.

There are three filters in the dashboard -

Fiscal Year - FY15,FY16,FY17, FY18 etc..

Fiscal Year Quarter - 2015/Q1,2015/Q2,2015/Q3,2015/Q4,2016/Q1 etc..

Fiscal Month - February, March, April etc....

In the attached chart I have the below set analysis in the measures.

Sum({<METRIC_NAME = {'approve'},CLASSIFY = {'CUSTOMER','PARTNER'}>}METRIC_VALUE). 

How do I create a second measure to show growth rate fiscal year over fiscal year?

[dwforest]

Use 2 dimensions,

Year and Month 

[ajinkyabhonsle]

Can you help me with the set analysis formula. to show that?

[Anismohamed32]

Hi , 

1.If you need a user to select the Sep month and the chart should show only the year wise split of value.

Sol: Drill down function : month and Year as dimension.

Note: You can find drill down dimension in the Masters section.

2. Showing month wise data for all the years is something very illogical, but if your requirement is to have that, do the following.

Sol :  *Have a filter pane which has month in it.

           *Then have a chart by having fiscal year as dimension in it. 

           *Set the calculation condition as Getselectedfieldcount(Month) >1 on the add-on tab on the right.