Get the sum for the current and previous fiscal year in KPI

[selvakumara]

I want to get the sum of count/ average of visitors for the current and previous fiscal year.

I need to display the total numbers visitors involved in KPI for the current and previous fiscal year.

Scenario . if i select year in the selection the total should be displayed for current and previous fiscal year.

The total is coming for the current fiscal year but doesn't for previous fiscal year.

How can i achieve it ?

[Anil_Babu_Samineni]

You can use this?

Sum(TOTAL count)/Avg({<[fiscal year] = {">=$(=Max([fiscal year]-1)) <=$(=Max([fiscal year]))"}>} Visitors)

[Anil_Babu_Samineni]

Second one

Count({<visitor = {'KPI'}, [fiscal year] = {">=$(=Max([fiscal year]-1)) <=$(=Max([fiscal year]))"}>} TOTAL Number)

[selvakumara]

Thanks Anil. I found an answer

[Anil_Babu_Samineni]

You can close this thread and mark as helpful ..

[selvakumara]

Anil have a Question

I have fiscal year. I want to extract the fiscal quarter

Eg.

Fiscal year - 2017 means , I want the quarter 2017-Q1,2017-Q2,2017-Q3,2017-Q4

In the data load editor, how can i achieve this ?

[sunny_talwar]

May be create a Fiscal Year calendar.... Also, look here

Fiscal and Standard Calendar generation