Platform

Hello @Saaraunsh Rege, I acknowledged your question, I'll get back to you with the best possible answer!

Thank you,
Varad Muthal

Hello @Saaraunsh Rege, Here is the answer from our CSM @Andy Liang

"Can you elaborate more on the use case? The display label is already identified on the x-axis in all Apptio charts"

Hi @Varad Rajeev Muthal and @Andy Liang, this is a business requirement. And if we select the 'Time' component as 'Year To Date' (or any other value), then the time component is displayed on the X-axis and not the labels.

Hello @Saaraunsh Rege, pasting response from @Andy Liang as he not able to write here:

there is currently no way of updating the value to reflect identifier.I would suggest to eliminate bringing YTD as time component and use YearToDate function and bring into value configuration into chart. This will allow x-axis to still display as identifier of the chart.

I hope this will help!

Hi @Andy Liang and @Varad Rajeev Muthal, thank you for the response. I can definitely suggest this option as this would be the best alternative at the moment.

However, there are two issues here.
1. The sorting is not working - This is a deal breaker!
Pic 1 shows sorted values when we use the Time component, the Pic 2 shows incorrect sorting when we use the YTD function.
I feel this is happening because the sorting is done on monthly values and the columns display YTD values.
Is there a way to sort the graph based on YTD values?

2. All the bars show the same color, refer Pic 2 below (not a deal breaker but still important). Can we have different colors like the one shown in Pic 1 below.

Pic 1 -

Pic 2 -

@Andy Liang Thank you so much. the sorting issue is resolved now.

For 2, we have a Color Palette for our environment already.  However, applying the color palette just changes the color but applies the same color to all columns. Refer below - Pic 1 becomes Pic 2 after applying the color palette.

Pic 1 -

Pic 2 -

@Saaraunsh Rege, can you share an snip of your chart configuration? 

Hi @Andy Liang,

It is a simple column chart with Legend = ID, Values = YTD of Cost, Axis contains nothing and we have 2 filters. The graph is sorted with YTD of Cost in descending order as you advised yesterday.
Anything specific that you are looking for?

Hi @Andy Liang, we were able to resolve this. It was a pretty simple fix which our CSM showed us.
We just had to check the below in the chart properties:

Thank you so much for your help and guidance. The changes were well appreciated :)