Selecting top X cases

Hi everyone,

for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:

  • Total expected value of the top X projects
  • Certain Process-KPIs like (Average development loops per project) etc.

Now I’m searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.

This might be interesting for everyone who want’s to have a look/comparison within their top X cases.

Best regards,
David

Hi David,

unfortunately, this is currently not possible. You’re welcome to post this idea as a feature request in the forum :slight_smile:

Best regards,
Viana

Hi David,

I think this can be solved with a new PQL function we will release in a few weeks on the IBC. With this function you can index rows based on a value, and then use this index to filter.

If you are on CPM4, I’m afraid you will need to wait for the next Release to also have access to the new function.

Best,
David

Hi,

thanks for your feedbacks and as we are on prem, I think we will have to wait a bit then and think about some work arounds :smiley:

Is there somewhere an update-list about new PQL-Expressions/general functionalities that are added in the IBC?

Best regards,
David