Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Cognos 11.1 Visualization Needs

    Posted 11/03/18 11:24 PM
    I searched the discussions for keywords on data aliases, boxplot, divergent bar graph, but did not find anything. 

    A)  I need to know how to give data values alias names on a graph so that data that has values 0, 1, and 2 can be graphed and instead of the Y or X axis showing 0 1 and 2, I could right click on the axis and give aliases of the appropriate words such as "Online Learner", "Resident" and "Commuter" if the question was about where the student was living.

    B)  How can we make a boxplot - these are critical to displaying data distributions in a compact understandable way, with data like ACT scores and comparing various attributes of an incoming class or previous year's classes, I can do them in Tableau and they are available as visuals in PowerBI


    C)  How can we make divergent stacked bar graphs [akin to a tornado graph] -- these are exceedingly helpful when displaying scale results, such as data from likert scale survey questions and very necessary for showing an admissions funnel-- I learned how to manipulate Tableau to do them, but I am not seeing this option in cognos analytics - I have a workaround that I can try but this should just be a ready to go visual or there should be a setting to "diverge" a stacked bar graph
    Stacked bar graph centered on middle scale value

    ------------------------------
    JR Malone
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos 11.1 Visualization Needs

    Posted 11/23/18 04:53 PM
    Hey JR,

    Thanks for posting in the community! 

    I'll go through your questions as they were stated.

    A.  Unfortunately, currently, you cannot give data aliases. You may want to create a separate column in your data based on an IF statement to get the names the way you want. I would also highly recommend posting it as an RFE (Request for Enahancement) so we can gauge the market need around this:
    IBM Software RFE Community: RFE Community

    B and C. Boxplots and tornadoes are available in 11.1 in Reports. If you are looking for the visualizations to be added into dashboards, I recommend logging an RFE for this. 

    We're constantly evolving our product based on user feedback, thank you so much for contributing to that.

    ------------------------------
    Sami El Cheikh
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 3.  RE: Cognos 11.1 Visualization Needs

    Posted 11/26/18 03:42 AM
    And please vote for this RFE that, if implemented, would allow all users to build their own visualisations. (and hopefully, share them again).

    Offer an open Rave2 API

    ------------------------------
    Reinier Battenberg
    ------------------------------



  • 4.  RE: Cognos 11.1 Visualization Needs

    Posted 03/11/21 01:38 PM
    @SAMI EL CHEIKH Can you clarify where to find the Tornado chart? We need a divergent stacked bar for visualizing survey data over time. We have 11.1.7 installed and I don't see a Tornado chart under the 11.1 visualizations. I also can't find it listed under the viz types available in 11.1 documentation.

    Your help is greatly appreciated! 

    Thanks,
    Wendi

    ------------------------------
    Wendi Lewis
    ------------------------------



  • 5.  RE: Cognos 11.1 Visualization Needs

    Posted 03/18/21 09:51 PM

    Hi @Wendi Lewis

    I should have been more clear, at the time I was referring to an older chart engine for both the tornado and box plot. The box plot was added in the 11.1.x stream as an out of the box 11.1 visualization, the tornado has not been updated yet.

    We have added a custom population visualization that may fit your needs in the accelerator catalog. You can import this into your environment. 

    https://community.ibm.com/accelerators/catalog/content/Population

    Hope that helps,
    Sami



    ------------------------------
    Sami El Cheikh
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 6.  RE: Cognos 11.1 Visualization Needs

    Posted 04/21/21 10:55 AM

    @SAMI EL CHEIKH Thanks so much for your reply. We may very well have a use case for your Population chart and downloaded it. 

    Hopefully someone from development is listening and will see the product needs a good option for a divergent stacked bar.​ 

    Thanks again,
    Wendi



    ------------------------------
    Wendi Lewis
    ------------------------------