IBM Apptio

 View Only

 Sorting Issue

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted Fri February 26, 2021 12:32 PM

Hi Team - Below is the issue description of the issue i am facing

Deprecation LIM tab has a table with Life in Month columns. These month values are not sorted properly ascending/descending because they are string values and the month number. This results in sorting not functioning as a user would ideally want out of these columns. 

I tried padding it with 0 using Numberformat formula, but still, it doesn't fix the month sorting . Attached are screenshot

Even though these fields are in strings, these needs to be sorted based on Numbers. Any help will be appreciated. Thank you


#CostingStandard(CT-Foundation)
Attachments  View in library
Screenshot 2021-02-26 at 10.54.07 PM.png 290 KB
Screenshot 2021-02-26 at 10.55.42 PM.png 40 KB
Apptio Community Member's profile image
Apptio Community Member posted Wed March 03, 2021 11:57 PM  Best Answer
Hi again @Ahamad Kedia,

I've come across the below option. Have a go at this and let me know if it works:

Check out the report, click on the Remaining LIM column in the report table, then (top/above) select Data > Edit and adjust the properties to: 'Type' = Numeric and make sure the 'Summable' box is ticked.

That should enable you to sort that column in descending/ascending order.

Thanks,
Michaelene
​ ​
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted Mon March 01, 2021 11:55 PM
Hi @Ahamad Kedia,

Thanks for your question.

I've had similar customer queries which do often require additional configuration to overcome, assuming it's possible to get around. There might be a way to easily make that field numeric only which would then mean you can easily sort on those remaining months.

I would however encourage you to reach out to your CSM who will likely put you in touch with your delivery consultant who should be able to shed some more light on this one for you in terms of what's possible in your model based on your config.​

Thanks,
Michaelene
#CostingStandard(CT-Foundation)
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Tue March 02, 2021 01:55 AM
In a table of ours—a TBMO change log—I did the following, to ensure that the most recent records appear on top:

In the table I have a column called Effective Date with something like "01-Oct-2018" (this I cannot sort properly)

I created a formula in the transform as follows:

Change Date=DateFormat(Effective Date,"MMM yy")

This converts the original value of "01-Oct-2018" to "2018.10.01", which I can sort in the report.
I added Change Date to the report in the data, sorted it descending, and then hid the column. Thus I can display the original date values, but sorted the way I want.



#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted Thu March 04, 2021 01:45 AM
Thank you @Michaelene Bassil that worked​​
#CostingStandard(CT-Foundation)

Related Content