This content has been marked as final.
Show 4 replies
-
1. Re: 3 condition KPI calculation help needed
Shinichiro MurakamiMar 16, 2016 8:09 AM (in response to Stephen Crocker)
Difficult to investigate without actual data.
Are you able to share your packaged workbook (***.twbx) .
Thanks,
Shin
-
2. Re: 3 condition KPI calculation help needed
John Sobczak Mar 16, 2016 8:15 AM (in response to Stephen Crocker)The key to calculated fields is that they are always at the row level unless you explicitly use aggregates in your calculations. Number of records will always be 1 at the row level. You can create a fix LOD calc by region to get a # of records at the row level {fixed [region] : sum(Number of Records] }
-
3. Re: 3 condition KPI calculation help needed
Derrick Austin Mar 16, 2016 8:17 AM (in response to Stephen Crocker)It sounds like you are not aggregating it up. Try this:
If attr(rgn_code) = 'Central' and sum([Number of Records]) > 1112 then 2 elseif attr(rgn_code) = 'Central' and sum([Number of Records]) < 999 then 0 else 1 end.
-
4. Re: 3 condition KPI calculation help needed
Stephen Crocker Mar 16, 2016 6:37 PM (in response to Derrick Austin)Thanks Derrick, I really appreciate the help.