Cognos Analytics with Watson

 View Only
  • 1.  Conditional highlighting in Dashboard presentation

    Posted Fri May 29, 2020 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 Mon June 01, 2020 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 Mon June 01, 2020 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 Mon June 01, 2020 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 Tue June 02, 2020 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
    ------------------------------



  • 6.  RE: Conditional highlighting in Dashboard presentation

    Posted Wed June 03, 2020 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
    ------------------------------



  • 7.  RE: Conditional highlighting in Dashboard presentation

    Posted Thu June 04, 2020 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
    ------------------------------



  • 8.  RE: Conditional highlighting in Dashboard presentation

    Posted Wed June 03, 2020 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
    ------------------------------



  • 9.  RE: Conditional highlighting in Dashboard presentation

    Posted Thu June 04, 2020 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
    ------------------------------