Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a filter called Fyear, which contains data from April 2018 to June 2020 and financial year starts from April.
In a bar chart, I need to display quarterly data , I am using quarter expression as below:-
Count({$<[Date]={">$(=QuarterStart(Max([Date]),-3)))<=$(=Quarterend(addmonths(Max([Date]),-9)))"}>}(score)) ( Gives 4,5,6 Months)
Count({$<[Date]={">$(=QuarterStart(Max([Date]),-2)))<=$(=Quarterend(addmonths(Max([Date]),-6)))"}>}(score)) (Gives 7,8,9 Months)
Count({$<[Date]={">$(=QuarterStart(Max([Date]),-1)))<=$(=Quarterend(addmonths(Max([Date]),-3)))"}>}(score)) (Gives 10,11,12 Months)
Count({$<[Date]={">$(=QuarterStart(Max([Date]),0,4)))<=$(=Quarterend(addmonths(Max([Date]),0)))"}>}(score)) (Gives 1,2,3 Months)
Above expression is working fine for FY18,FY19, but for FY20, I am facing issues as FY 20 is not yet closed. for Q1 I am getting (10,11,12) months data of 2019, as it;s subtracting from the available data set.
for Q1 , it should dispaly (4,5,6) months data of 2020, as for FY 20 I have data available till June month.
Regards