Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Expand all | Collapse all

Apptio BI / CLDY Enhancements: Displaying as Net or Percent & Decimals

  • 1.  Apptio BI / CLDY Enhancements: Displaying as Net or Percent & Decimals

    Posted Tue August 09, 2022 05:50 PM
    Edited by Connor Kinkead Tue November 05, 2024 05:30 PM
    Hi everyone, happy Tuesday. I wanted to fill you in on the latest release for Apptio BI, which adds the ability to display net or percent variance when comparing Cloudability and Cost Transparency data across two date ranges. As a report editor in Apptio BI, you need to be able to customize the way charts and tables appear on a report, as it allows you to help focus viewers attention on specific areas or maintain corporate standards. Cloudability already supports the ability to allow users to pick whether they can see the net value or percentage value of variance when comparing two dates, and now Apptio BI supports this as well. 

    When creating a new visualization and using a CT or Cloudability data source, leverage the custom date range comparison feature in your window (using "Compare" in your custom date range window), and select a KPI or table visual to display your data. In your Options tab, you can now select Display Change as to be Net or Percent, and can select the color coding (red and green) for the up and down arrows on your visualization with Comparison Arrow.

    In addition to this release, BI users can now set decimal precision for metrics and includes a formatting enhancement for variance values in tables. When adding a Metric to a visualization, a dropdown now appears to help you specify the number of decimal places you would like to see displayed.  You can set the decimal places to 0, 1, or 2. To specify the decimal places, click the down arrowhead, and select the applicable value from the dropdown. All metrics and comparison values display two decimal places by default. You can set the Shorten Metrics and Shorten Comparison toggle switches on the Options tab to use short number formats for these values.

    What are your thoughts on this release? What would you like to see released in Apptio BI related to Cloudability and CT? Let us know!
    #ApptioBI


  • 2.  RE: Apptio BI / CLDY Enhancements: Displaying as Net or Percent & Decimals

    Posted Tue August 09, 2022 09:23 PM
    Connor,

    Unfortunately the decimal precision of max 2 places is not enough for Non USA customers to report Foreign Exchange rates, which require minimum 4 decimal places and preferably 6 decimal places.

    I like the other enhancements, but one that would be really really valuable is the ability to compare Cloudability and Cost Transperancy values in Apptio BI. That would allow us to identify where values have not been interfaced or need updates to be performed.

    John Feore


  • 3.  RE: Apptio BI / CLDY Enhancements: Displaying as Net or Percent & Decimals

    Posted Mon August 15, 2022 01:02 PM

    Hi @John Feore , thank you for your feedback! Noted about the decimal places, we will work with the product team to determine​ next steps on that given the foreign exchange rate requirements. 

    As for the comparison of CLDY and CT values in BI, this is something we are working on with cross data source comparisons moving forward. However, if you have not already posted a request here on the community page, I encourage your to please do so. While I always share these comments with the team it helps with tracking.