IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


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.

IBM Employees should enter Ideas at https://ideas.ibm.com


Add a new idea Subscribe
Status Under review
Workspace Planning Analytics
Created by Guest
Created on Mar 5, 2024

RELATED IDEAS

Legend sort in charts according to the selected set, even with the zero suppressioin

At the moment if you show the legend for your chart, it doesnt matter what type of charts, you cannot use the zero suppression for sure. 
The sorting order is functioning not according to your set but according to your values, it is not practical and disappointed. 

It means, that e.g. you have some values for Argentina in 2024, however, for Belgium in 2020, for the legend you get Belgium as first country, and Argentina as a second country. But you want and you need Argentina as a first country. 

The answer from support team: 
The non alphabetical sort of the elements in chart legends when the elements in dimension are sorted alphabetically is going to be a permanent limitation of our software, the alphabetical order of members in the chart's legend is not guaranteed when zero suppression is turned on.

 

Thank you very much in advance. 

With best regards, 
Vitalij

 

Needed By Yesterday (Let's go already!)
  • Guest
    Reply
    |     Mar 5, 2024

    Hello Stuart,

    in my usecase for the support issue, I have some additional information.
    I tried it with the cube sales.

    Here is my mdx for the dimension "region" that is my row dimension.


    #######################
    ORDER(EXCEPT(DISTINCT({[region].[region].[World],DESCENDANTS([region].[region].[World] , 99 , LEAVES)}) , {[region].[region].[World]}) , [region].[region].CURRENTMEMBER.PROPERTIES("MEMBER_NAME") , BASC)

    #######################


    Concerning the values, I put some values to Argentina, e.g. for August and some values to Belgium / Brazil to a month a bit earlier, and as a result, you get such a view: with Brazil / Belgium and only after that Argentina.

    I will add here my screens from the support case.

    sData - SalesCu...
    sData - SalesCu...
    sData - SalesCu...
    sData - SalesCu...
    sData - SalesCu...
    sData - SalesCu...
    sData - SalesCube - 2. Nullwertunterdrückung im Diagramm - Argentina mit Wert.png
    Open full size
    sData - SalesCube - 3. Nullwertunterdrückung im Diagramm - Argentina und Brazilien mit Wert - Reihenfolge kaputt.png
    Open full size
    sData - SalesCube - 1. ohne Nullwertunterdrückung.png
    Open full size
    sData - SalesCube - 4. Nullwertunterdrückung im Diagramm - Argentina und Brazilien mit Wert - Reihenfolge kaputt - Feld Month gewechselt.png
    Open full size
    sData - SalesCube - 66. sample with region_n, actual, model_n.png
    Open full size
    sData - SalesCube - 5. Nullwertunterdrückung im Diagramm - Feld Month zurückgewechselt - Reihenfolge passt.png
    Open full size
    sData - SalesCube - 2. Nullwertunterdrückung im Diagramm - Argentina mit Wert.png sData - SalesCube - 3. Nullwertunterdrückung im Diagramm - Argentina und Brazilien mit Wert - Reihenfolge kaputt.png sData - SalesCube - 1. ohne Nullwertunterdrückung.png sData - SalesCube - 4. Nullwertunterdrückung im Diagramm - Argentina und Brazilien mit Wert - Reihenfolge kaputt - Feld Month gewechselt.png sData - SalesCube - 66. sample with region_n, actual, model_n.png sData - SalesCube - 5. Nullwertunterdrückung im Diagramm - Feld Month zurückgewechselt - Reihenfolge passt.png
  • Admin
    Stuart King
    Reply
    |     Mar 5, 2024

    Hi Vitalij,

    I'm not sure I understand the issue you are presenting. I did a quick test with a bar chart using a single dimension (countries) on the row axis. I sorted the members alphabetically using the set editor sort option.

    Without suppression I see this:


    With suppression enabled I see this:


    It appears that the sort order is persisting.

    The legend appears to match the order of members in the rows axis of the source view.

    image.png
    image.png
    image.png
    Open full size
    image.png
    Open full size
    image.png image.png

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.