IBM Sustainability Software - Ideas Portal
This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. 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 an idea.
Get feedback from the IBM team and other customers to refine your idea.
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.
Hi @Guest
In order to refine the sorting of the field names in social metrics accounts there are ways to achieve this.
1. Rename the fields : as KPI fields are sorted alphabetically, adding a prefix to the KPI names will allow you to sort then using this prefix instead of the kpi name.
2. Create accounts : create accounts for each KPI group, and add an identifier to the account (through any of the free text fields available to accounts (source, id, attribute, etc), you can sort by this identifier instead of the kpi details
3. Use environmental accounts instead of social metrics : environmental accounts are able to be used to more flexibly return data, including the native ability to return units of measure, unit normalization, aggregation through the data type groups functionality and intensities using the ratios functionality. These functions provide you with more ways to aggregate and sort data.
4. Create a virtual DAX measure in PowerBI Developer to create a sort order based on the kpi name (replace kpi names below with relevant actual names) this option can have an effect of performance if there are a large volume of social metrics fields : the field created by the below measure can be used in a table, and sorted by the value returned as long as the field name is also part of the table.
KPI Sort = VAR _kpi = SELECTEDVALUE('Social Metric'[Social Metric Field Name])
RETURN
switch( TRUE(), _kpi = "Non-hazardous waste", 3, _kpi = "Hazardous waste", 2, _kpi = "Total waste", 1)
5. Use the fields from the "Social Metrics" table which is the social metrics kpi fields split by field name : add the fields as values into a matrix table and under the Values section of the formatting options, turn on "Switch values to rows" to return the data in the order of the fields in the "Values" section of the table.