Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am getting , "The chart is not displayed because it contains only undefined values" this message
my measure is-
Sum({<[Status] ='Closed - Meets Standard',[Org level 1]='Global Operations',[Work location country/territory]='Ireland'>+<[Status] ='Closed - Meets Standard',[Org level 1]='Accenture Operations',[Work location country/territory]='Ireland'>}If(date(Floor([Accenture start date])) - Date(floor(Closed)) >= 2, 1, 0))/
Sum({<[Status] ='Closed - Meets Standard',[Org level 1]='Global Operations',[Work location country/territory]='Ireland'>+<[Status] ='Closed - Meets Standard',[Org level 1]='Accenture Operations',[Work location country/territory]='Ireland'>}if(Date(floor([Accenture start date])) - Date(floor(Closed)) >= 0,1,0))
Dimention is =[Accenture start date.autoCalendar.YearMonth]
Please guide me where I am going wrong
To start, your set analysis values should be in { } so like...
[Status] = {'Closed - Meets Standard'},