Cloud Management and AIOps


This is an IBM Automation portal for Cloud Management, Technology Cost Management, Network Automation and AIOps products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Future consideration
Workspace Apptio
Categories TBM Studio - Data/Model Studio
Created by Guest
Created on May 1, 2024

RELATED IDEAS

New pipeline step for Sort

Would like to have a new step in the transform pipeline which allows us to select a column and sort it by value (if numerical field) or alphabetically (if text field).

Use Case 1

  • Generally when admin are going through tables and are investigating something then we would usually sort by highest dollar value to bring those things to our attention first
  • It would be good to have the ability to do this once via a 'sort' step rather than having to click on the field every time we go into the table

Use Case 2 

  • The TableMatch formula looks at the rows of the rules table in the order in which they appear
  • It makes sense to have longer text strings higher in the rules table to result in a better match
  • When we manually load the source table, we do this in Excel using a 'length' (=len) formula to order the data by the length of the keyword
  • As we are moving a lot of our manual inputs to Editable Tables, it would be a lot better to be able to do this in the pipeline as users using Editable Tables will not know that the order of the keywords in the rules table matter
  • ADMIN RESPONSE
    Dec 9, 2024

    For Use Case 2, the TableMatch() function includes an optional sort column:

    Syntax: TableMatch(Rules Table, Column, sort=ColumnName_to_Sort,  sortOrder=asc|desc,  exclude=ColumnName_to_Exclude,exclude=...)

    • sort is optional
    • sortOrder is optional, defaults to ascending
    • exclude is optional

    Example: =TableMatch(Cost Center Rules,Cost Center, sort=Cost Center, sortOrder=asc, exclude=SomeColumn1, exclude=SomeColumn2)

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.