Cognos Analytics

Cognos Analytics

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

 View Only
Expand all | Collapse all

Add an intuitive information message to a dashboard

  • 1.  Add an intuitive information message to a dashboard

    Posted Thu February 06, 2020 12:51 PM
    Hello, I am a very new user to IBM Cognos. I have built a dashboard in Cognos and would like to add an intuitive descriptor to show users exactly what the numbers they are seeing represent. If anyone could point me in the right direction that would be very appreciated.



    ------------------------------
    Valerie Ryan
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Add an intuitive information message to a dashboard

    Posted Thu February 06, 2020 02:18 PM
    Hi Valerie,

    You can checkout the link below about formatting Dashboards.

    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/wa_formatting_intro.html.

    Thanks
    Steve

    ------------------------------
    Steve Templeton
    ------------------------------



  • 3.  RE: Add an intuitive information message to a dashboard

    Posted Thu February 06, 2020 02:58 PM
    Your link did not work. Can you try a fresh copy and paste.

    ------------------------------
    Valerie Ryan
    ------------------------------



  • 4.  RE: Add an intuitive information message to a dashboard

    Posted Thu February 06, 2020 03:13 PM
    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/wa_an_assembling_a_dashboard.html

    Try this link

    ------------------------------
    Steve Templeton
    ------------------------------



  • 5.  RE: Add an intuitive information message to a dashboard

    Posted Thu February 06, 2020 03:28 PM
    Yes that one worked. It's a great resource and I will definitely use it however I did not see any area that would address my question. I'm thinking there may be some coding involved if it is possible.

    ------------------------------
    Valerie Ryan
    ------------------------------



  • 6.  RE: Add an intuitive information message to a dashboard

    Posted Fri February 07, 2020 08:13 AM
    Hi Valerie,

    I spoke to a co worker and they suggest the following:

    Your best bet may be just to add a text widget to the appropriate spot on the dashboard, and then add the text for the intuitive descriptor:


    We're not sure that there is a way to add a custom tooltip to a dashboard visualization or widget. On a computer (not a mobile device), you can put your mouse cursor over a section of a visualization and you will see the default tooltip, but to our knowledge the text in the tooltip can't be changed.


    ------------------------------
    Steve Templeton
    ------------------------------



  • 7.  RE: Add an intuitive information message to a dashboard

    Posted Fri February 07, 2020 08:36 AM
    So I think what you are saying if that I can't do what I'm looking for, is that correct? Can any variable be added to the text box such as today's date. ie - Today is #date . If so, what is the syntax for that

    ------------------------------
    Valerie Ryan
    ------------------------------



  • 8.  RE: Add an intuitive information message to a dashboard

    Posted Fri February 07, 2020 10:28 AM
    Edited by System Admin Fri January 20, 2023 04:20 PM
    Hi Valerie,

    You could create a calculation that would look at the selections made on dashboard and print output accordingly. The output message can then be displayed in the List visualization. With the new version (I tested this on CA11.1.2 and 11.1.5) you can customize the list text to just look like your title. This will give you the dynamic title you are looking for.


    For my Dashboard I did the following:
    CASECASE WHEN (((count (distinct MONTH_NAME)) = 1) AND ((count (distinct FISCAL_YEAR_NUM )) = 1) ) 
    THEN    ('' + '' + NURSE_UNIT_DESC +  ' ' + PROGRAM + ' ' + MONTH_NAME +' '+ FISCAL_YEAR + ' Occupancy Rate')

    Count distinct of the parameter looks for the values that are selected part of that filter. You can have custom message built in the case output to give you 'Text that you are looking for ' + current_date

    Screenshot of My Example - the title will be dynamic based on selection made to program, month and year
    Screenshot with Filter selections of Month and Year:


    Sri


    ------------------------------
    Sri Vijay Bharat Peddi
    ------------------------------



  • 9.  RE: Add an intuitive information message to a dashboard

    Posted Fri February 07, 2020 01:50 PM
    You can try to create Calculation in Data Module using different attributes and facts used on Dashboard and concatenated with desired Text. This calculated field can be dragged on Dashboard as Summary Visualization to show content.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 10.  RE: Add an intuitive information message to a dashboard

    Posted Wed February 12, 2020 12:59 PM
    ​It seems to me that this would depend on your data source the dashboard uses. Are you using a database or an external file like a workbook? Does the data source current contain a column that represents what the numbers they see correspond to? For example Product, Location, etc.?

    You could then drag this field onto your tab or all tabs filter (image attached), or create a prompt so that users can select the descriptor. If the data source is not robust enough as is and you have time to experiment, you could use the GO! data warehouse Cognos offers.
    Otherwise you may need to add more fields to your dataset in order to build the dashboard you're envisioning.

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cxr.10.1.0.doc/ug_cxr_id6094samples_chapter_heading.html#samples_chapter_heading

    ------------------------------
    Kind regards,
    Elizabeth Griffin
    ------------------------------