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.  Conditional highlighting in Dashboard presentation

    Posted 05/29/20 01:16 PM
    Hi,

    On the Cognos Analytics Dashboard do we have the feature of Conditionally highlighting a row (on Table Visualization) ?

    Example - I would like to compare two days X and Y, and if X > Y I need to highlight the row with RED, if X < Y, then highlight with Amber and X = Y, highlight with Green...

    If the feature is available can you please suggest how this will be done?

    ------------------------------
    Chandra
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/01/20 10:16 AM
    HI Chandra,

    You should be able to create a calculation with a case state that defines your criteria and then use the new calculation to conditional format in the table. If you add the calculation to the table it will only highlight the calculation field, but if you don't it'll highlight the whole row.

    Hope this helps.

    ------------------------------
    Nipun Gupta
    ------------------------------



  • 3.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/01/20 11:00 AM
    Hi Chandra, see this video Easily create dashboards in conditional formatting in a grid visualization.
    Hope this helps.

    ------------------------------
    Ahmed Abdel-Baky
    ------------------------------



  • 4.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/01/20 04:14 PM
    This is how I'd do it:

    Create a new data item. 
    IF ( X > Y ) THEN
    ( 'Red' )
    ELSE IF (X = Y) THEN
    ( 'Amber')
    ELSE
    ('Green')

    Then add the conditional formatting based upon the values you defined in this new data item.

    Jeanie

    ------------------------------
    Jeanie Krieger
    Business Analyst
    California State University, Sacramento
    Sacramento CA
    ------------------------------



  • 5.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/02/20 04:05 AM
    Hi, 

    Thank you for your quick response..

    I created Date_Highlight as below.

    IF ( X > Y ) THEN
    ( 'Red' )
    ELSE IF (X = Y) THEN
    ( 'Amber')
    ELSE
    ('Green')
     

    Used variable Date_Highlight for color, but that doesn't highlight the rows as I expected. Is there any other properties to be updated to get the color highlighted as per values?



    ------------------------------
    Chandrashekhara Kundadka
    ------------------------------

    Original Message


  • 6.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/03/20 05:46 AM
    Hi,

    the calculated measure should return values, you should change the calculated measure to:

    IF ( X > Y ) THEN
    ( 1 )
    ELSE IF (X = Y) THEN
    ( 2)
    ELSE
    (3)

    then select the option of the colors and prepare it so that it has 3 conditions and that they are red, amber and green


    with these steps you get it

    Regards


    ------------------------------
    Luis Moreno
    ------------------------------

    Original Message


  • 7.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/04/20 06:10 AM
    Thank you Luis. The steps which you have mentioned worked.

    Thank you everyone on this thread for providing the suggestions/solutions.. Appreciate it.

    ------------------------------
    Chandrashekhara Kundadka
    ------------------------------

    Original Message


  • 8.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/03/20 05:30 PM
    Chandrashekhara,
    So now you will need to highlight the Date_Highlight field, open up properties and select Conditional Style.  I created a string for this data load report with the names of the colors, that you've also done.  Add string conditions and in the style, choose the background (or foreground) colors.  That should complete your report to be the colors you define.  



    Load Status Report
    Good Luck, you are almost there.

    Jeanie


    ------------------------------
    Jeanie Krieger
    Business Analyst
    California State University, Sacramento
    Sacramento CA
    ------------------------------

    Original Message


  • 9.  RE: Conditional highlighting in Dashboard presentation

    Posted 06/04/20 06:14 AM
    Thanks Jeanie for the response. I believe these steps are on Reports, that is useful info.  Appreciate your time on helping to resolve the issue.

    ------------------------------
    Chandrashekhara Kundadka
    ------------------------------

    Original Message