As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
I'm new to PMF, so I'm hoping I'm missing something obvious.
I'm using a percentage aggregation to calculate employee turnover ([Terminations] / [Avg Monthly Headcount]), which works fine for each month. For the YTD calculation, PMF sums all of the terminations, which is good, but it also sums all of the monthly headcounts, which I don't want. I need the denominator to be an average of the monthly results rather than a sum. Is this possible?
The formula for monthly is simply (Monthly Terms) / (Monthly Headcount), which works fine. The formula for YTD Turnover is SUM(Monthly Terms) / AVERAGE(Monthly Headcount), which is where I'm having the problem. PMF doesn't give me the option to use an average, so when it calculates the YTD (or any other period of time), it adds all of the terms, which is good, but also adds all of the monthly headcounts, which is bad.
This is a standard HR measure, so I can't imaging that I'm the first person that has needed this. I have several measures that need the same concept with different denominators (ex. Avg Days per Month).
All that said, remember I'm a newbie to PMF, and I should also add that I don't have a coding background. For any type of coding like was suggested above, where do I even do this in PMF?
I appreciate any help I can get. The answer I got from IBI Tech Support was "I'm afraid it is not possible. I'm sorry we have no plan to implement this feature for now and it is not available." Given that these are common measures, I refuse to give up so easily!
Hi Mike, The only place for this to get done would be in the reporting core code in PMF because it is actually a different aggregation method - the denominator has to be averaged at reporting time, not when the data is loaded into the mart.
If we were to add this capability, it would mean you'd need to upgrade to the version of PMF that supported it.
PMF 8.1.1 is about to ship and won't have this.
The next release will be 8.1.2, sometime around the end of Jan/beginning of Feb 2016.
Would it work for you if we did it then?
Side benefit is you would get our new gorgeous dashboard system (coming out in 8.1.1) with that upgrade.
Let us know.
Bob Jude Ferrante Director of Business and Development WebFOCUS Performance Management Bob_Ferrante@ibi.com 917-339-5105
I'll take any questions about PMF - business or technical - anytime!