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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at email@example.com for further assistance. Reference the community FAQ to learn more about the community.
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!