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.
------------------------------
Jeanie Krieger
Business Analyst
California State University, Sacramento
Sacramento CA
------------------------------
Original Message:
Sent: Tue June 02, 2020 04:05 AM
From: Chandrashekhara Kundadka
Subject: Conditional highlighting in Dashboard presentation
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:
Sent: Mon June 01, 2020 04:14 PM
From: Jeanie Krieger
Subject: Conditional highlighting in Dashboard presentation
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
Original Message:
Sent: Fri May 29, 2020 01:16 PM
From: Chandrashekhara Kundadka
Subject: Conditional highlighting in Dashboard presentation
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