------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi Vitor,

it seens you have ti fix the x axis. In your first example it is from -15 to +15.

Hope it works

Michael

------------------------------
Michael Kirschsiefen
------------------------------

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 



------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi @Zachary Taylor is this ​​CTRL + / + Q available in version 11.0.11?  I've tried and I don't see the JSON doc as you've described.

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------

Original Message:
Sent: Mon October 28, 2019 10:36 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi @Jenifer Broughton the CTRL +/+Q ​command brings up the dashboard specifications page in 11.0.13 (is read only), but I'm not 100% sure on whether it should be working in 11.0.10.  (See below screenshots of 11.0.13 vs 11.1.4).  This link doesn't show that command available for 11.0.10, but here are some other keyboard shortcuts for various versions: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_buxc.doc/c_ug_buxc_keybd_shtcts_dash.html  

(In 11.1.4, another way to do this is to select a widget/visual and hit CTRL+Period and you get a menu that allows you to select "Show Details" which will take you to the same page.)

Feel free to send me a direct message too if you want to talk more about how you're modifying the dashboard. 



------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Tue October 29, 2019 12:57 PM
From: Jenifer Broughton
Subject: Conditional Formating in a Table using Dashboard

Hi @Zachary Taylor is this ​​CTRL + / + Q available in version 11.0.11?  I've tried and I don't see the JSON doc as you've described.

Thanks,
Jen

------------------------------
Jenifer Broughton

Original Message:
Sent: Mon October 28, 2019 10:36 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Thanks guys!

The CTRL+FWD SLASH+Q worked for me!

Cheers

------------------------------
Vitor Flisch Cavalanti
------------------------------

Original Message:
Sent: Wed October 30, 2019 10:34 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi @Jenifer Broughton the CTRL +/+Q ​command brings up the dashboard specifications page in 11.0.13 (is read only), but I'm not 100% sure on whether it should be working in 11.0.10.  (See below screenshots of 11.0.13 vs 11.1.4).  This link doesn't show that command available for 11.0.10, but here are some other keyboard shortcuts for various versions: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_buxc.doc/c_ug_buxc_keybd_shtcts_dash.html  

(In 11.1.4, another way to do this is to select a widget/visual and hit CTRL+Period and you get a menu that allows you to select "Show Details" which will take you to the same page.)

Feel free to send me a direct message too if you want to talk more about how you're modifying the dashboard. 

 

------------------------------
Zachary Taylor

Original Message:
Sent: Tue October 29, 2019 12:57 PM
From: Jenifer Broughton
Subject: Conditional Formating in a Table using Dashboard

Hi @Zachary Taylor is this ​​CTRL + / + Q available in version 11.0.11?  I've tried and I don't see the JSON doc as you've described.

Thanks,
Jen

------------------------------
Jenifer Broughton

Original Message:
Sent: Mon October 28, 2019 10:36 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi @Jenifer Broughton I just tested in 11.0.10 - the specs page is available if you enter CTRL+FWD SLASH+Q, but similar to 11.0.13, it is read only. See below:

​

------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Tue October 29, 2019 12:57 PM
From: Jenifer Broughton
Subject: Conditional Formating in a Table using Dashboard

Hi @Zachary Taylor is this ​​CTRL + / + Q available in version 11.0.11?  I've tried and I don't see the JSON doc as you've described.

Thanks,
Jen

------------------------------
Jenifer Broughton

Original Message:
Sent: Mon October 28, 2019 10:36 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

The section can be found under Conditions when you use CTRL+FWD SLASH+Q. This works for me in CA 11.1.2. It is finicky, sometimes doesn't work with the color palette expanded. Try closing the dashboard and reopen and edit without expanding the color palette.

"conditions": {
         "palette": {
             "colors": [
                  {
                          "value": 1
                  },
                  {
                          "value": 2
                  }
                          ]
         }
}

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

Original Message:
Sent: Wed October 30, 2019 10:41 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi @Jenifer Broughton I just tested in 11.0.10 - the specs page is available if you enter CTRL+FWD SLASH+Q, but similar to 11.0.13, it is read only. See below:

​

------------------------------
Zachary Taylor

Original Message:
Sent: Tue October 29, 2019 12:57 PM
From: Jenifer Broughton
Subject: Conditional Formating in a Table using Dashboard

Hi @Zachary Taylor is this ​​CTRL + / + Q available in version 11.0.11?  I've tried and I don't see the JSON doc as you've described.

Thanks,
Jen

------------------------------
Jenifer Broughton

Original Message:
Sent: Mon October 28, 2019 10:36 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor,  

Another tip with conditional formatting on crosstabs is to pull up the dashboard specs page and enter the values you want by hand: 

1) Hit CTRL + / + Q to view the JSON doc with dashboard specs
2) In your browser, search for "conditional" to find the specs for the conditional formatting
3) Update the values you want there
4) Click update to apply changes

This helps if you have many different categories or a large range of numbers and it's difficult to use the slider. 

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi Vitor, did the comments below help you get what you needed?

------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Im hopeful someone in this thread will see my post.   I am working with CA 11.1.1,  creating a dashboard using a crosstab, and conditional formatting is very glitchy.  I have reviewed my JSON (Ctrl+/+Q) and I cannot locate  'conditions'...  However I am not sure what I am missing,  I have successfully worked with editing conditional colors with other dashboards with success.  This is my last ditch effort before I decide perhaps this dashboard is corrupt and start from scratch.   (this is a dashboard with multiple tabs, and multiple frameworks)

Upon clicking the rainbow icon (edit conditional formatting), the frame below appears however no data is displayed.
Thank you in advance for your assistance.



------------------------------
Jennifer Buckley
------------------------------

Original Message:
Sent: Thu October 31, 2019 10:27 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor, did the comments below help you get what you needed?

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Hi Jennifer, I'll send you a private message to see if we can try to connect over the phone. Thanks.

------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Mon December 30, 2019 02:02 PM
From: Jennifer Buckley
Subject: Conditional Formating in a Table using Dashboard

Im hopeful someone in this thread will see my post.   I am working with CA 11.1.1,  creating a dashboard using a crosstab, and conditional formatting is very glitchy.  I have reviewed my JSON (Ctrl+/+Q) and I cannot locate  'conditions'...  However I am not sure what I am missing,  I have successfully worked with editing conditional colors with other dashboards with success.  This is my last ditch effort before I decide perhaps this dashboard is corrupt and start from scratch.   (this is a dashboard with multiple tabs, and multiple frameworks)

Upon clicking the rainbow icon (edit conditional formatting), the frame below appears however no data is displayed.
Thank you in advance for your assistance.

Perhaps something in my calculations is not allowed, using the conditional formatting....
IF ( ( _days_between(current_timestamp, [XXXXXX].[xx_xx_VEND].[DUE_DATE]) BETWEEN 1 and 30 ) and ( [REAS_CD] not contains 'OSDC-' or [REAS_CD] is null ))
THEN
( [XXXXXX].[xx_xx_ACTG].[LN_AM]-[XXXXXX].[xx_xx_ACTG]].[AL_CLSD_AM])
ELSE (0 )
---------------
if ([XXXXXX].[xxxx_Reas_CD_Trumped].[REAS_CD] is null) then
([XXXXXX].[RE_DOC_ACTG].[REAS_CD])
else
([XXXXX].[xxxx_Reas_CD_Trumped].[REAS_CD])

------------------------------
Jennifer Buckley

Original Message:
Sent: Thu October 31, 2019 10:27 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor, did the comments below help you get what you needed?

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

When I use this method, it looks great till I add a filter. When changing the filter the table reverts back to 5 values. Is there a way to use filters and stop this from happening?

------------------------------
BILL DONOVAN
------------------------------

Original Message:
Sent: Thu October 31, 2019 10:27 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor, did the comments below help you get what you needed?

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson

Bill, Jennifer and I spoke and determined that removing the global filters for another data package fixed the problem.  If you can share some screenshots, we can see if you've got the same scenario, or we can connect elsewhere. I'lll send you my email address so we can speak directly if needed.

------------------------------
Zachary Taylor
------------------------------

Original Message:
Sent: Tue December 31, 2019 08:36 AM
From: BILL DONOVAN
Subject: Conditional Formating in a Table using Dashboard

When I use this method, it looks great till I add a filter. When changing the filter the table reverts back to 5 values. Is there a way to use filters and stop this from happening?

------------------------------
BILL DONOVAN

Original Message:
Sent: Thu October 31, 2019 10:27 AM
From: Zachary Taylor
Subject: Conditional Formating in a Table using Dashboard

Hi Vitor, did the comments below help you get what you needed?

------------------------------
Zachary Taylor

Original Message:
Sent: Fri October 25, 2019 01:32 PM
From: Vitor Flisch Cavalanti
Subject: Conditional Formating in a Table using Dashboard

Hi Guys,

I am struggling with conditional formating in a table using Dashboard.

I have a calculated field which will give me a difference between the item and provincial average of that item. If the difference is greater than 0 it should be red otherwise green.

I set the conditional range like this including some space either for the negative and positive sides to guarantee I covered all

But when I select other manager for example using a filter it changes the configuration.

Does anyone knows how to fix this configuration?

------------------------------
Vitor Flisch Cavalanti
------------------------------

#CognosAnalyticswithWatson