IBM Apptio

IBM Apptio

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

 View Only
  • 1.  HTML Bullet Point Bringing {Various}

    Posted Mon May 20, 2019 10:27 AM

    Hi,

     

    I'm trying to do some changes in the App - Detail Report in R12. All I'm trying to do is adding a new bullet point to the HTML but I want it to bring all the values in there for the specific Application but it's giving me {Various}.

    If we go to to the Application List Report we can see that the Application bellow has four SVC Codes and when we drill down to this Application we have {Various} for the bullet point. Is it possible to instead of giving me {Various} it brings all the SVC Codes separated by comma?

     

    Application List Report:

     

    App - Details Report:

     

     

    I'm not a big user of HTML so I just added a row for the SVC Code in the 'App - Detail Report' but let me know if there's a way to show all the information.





    #CostingStandard(CT-Foundation)


  • 2.  Re: HTML Bullet Point Bringing {Various}

    Posted Mon May 20, 2019 01:09 PM

    Hello @Caio Reiter, the reason it shows {Various} could be because the "Global Learning Platform" application has multiple SVC Codes in the raw data. What I would do for simplification is to directly upload the data with the SVC Codes separated by commas for each application and replace the current field you added to the HTML with the new one. For what I have seen when trying to do this, is that the data needs to be grouped and separated by commas since the raw data upload or at a transform step within a table itself. Please let me know if this works.


    #CostingStandard(CT-Foundation)


  • 3.  Re: HTML Bullet Point Bringing {Various}
    Best Answer

    Posted Mon May 20, 2019 04:01 PM

    Based on an article that I read, https://tbmcouncil.jiveon.com/message/1441 , I don't think there is a quick way of grouping down values and separate them by commas. It suggests the creation of a table transform and then the leveraging of the UniqueValues() formula. I tried it on a table I have on my side and worked.

     

    How I think it could work for you is:

     

    1) Build a table transform out of your applications' raw data

    2) From the source dataset table, do a UniqueValues function: SVC Code Concat=UniqueValues(Table Transform:SCV Code[Application Name=Application Name]) . This formula will bring back the SVC Codes in a format with quotation marks:

    "SVC1","SVC2","SVC3",etc.

     

    If you want to remove the quotation marks, you need to add the following steps:

     

    3) Add two additional formulas to remove the quotation marks:

       - Quotation Mark=Left(SVC Code Concat,1)

       - SVC Code Final=Substitute(SVC Code Concat,Quotation Mark,"")

    4) Add the SVC Code Final to your HTML component, {various} should no longer show.

     

    It may not be the shortest way, but it works. I hope it helps!


    #CostingStandard(CT-Foundation)


  • 4.  Re: HTML Bullet Point Bringing {Various}

    Posted Mon May 20, 2019 02:02 PM

    OR as an alternative, you can change the HTML to a table to list all the SVC Codes for you when you drill down to a particular App. Please let us know how you get on... @Caio Reiter


    #CostingStandard(CT-Foundation)


  • 5.  Re: HTML Bullet Point Bringing {Various}

    Posted Thu May 23, 2019 05:35 AM

    @Gustavo Paez, @Gulcin Menekse it works! Took me a while to make it work without circular reference but now the report looks good.

    Thank you very much both of you.


    #CostingStandard(CT-Foundation)