​Hi all

I am trying to create reports in workspace am fairly new to the IBM PA and taking a course on data and creating report.

However the training module does not give any idea on how to do conditional formatting with regards to getting  top 10 and bottom 10 variance by account and highlight the same.



Any input will be super helpful.

TIA

------------------------------
Dhwani Talsania
------------------------------

#PlanningAnalyticswithWatson

Hi Dhwani,

You can use PA for Excel, leverage conditional formatting Top/Bottom Rules, set color coding, then publish to PA Workspace.

If you need to do this in PA Workspace natively, I haven't found the same capability. But, you can create a calculation, use rank, then set conditional formatting to something like 'yourcolumn >= value 10' to color code the top 10. Of course, you can hide the calculated column.
See the screen for a sample highlighting top 5 with green and bottom 5 with red.




------------------------------
Tom Kim
------------------------------

Original Message:
Sent: Thu September 19, 2019 01:14 PM
From: Dhwani Talsania
Subject: Workspace : how to do a top 10 and bottom 10 variance by account

​Hi all

I am trying to create reports in workspace am fairly new to the IBM PA and taking a course on data and creating report.

However the training module does not give any idea on how to do conditional formatting with regards to getting  top 10 and bottom 10 variance by account and highlight the same.

Any input will be super helpful.

TIA

------------------------------
Dhwani Talsania
------------------------------

#PlanningAnalyticswithWatson

​Thank you so much for your response Tom, I was able to do it successfully.

------------------------------
Dhwani Talsania
------------------------------

Original Message:
Sent: Fri September 20, 2019 12:57 PM
From: Tom Kim
Subject: Workspace : how to do a top 10 and bottom 10 variance by account

Hi Dhwani,

You can use PA for Excel, leverage conditional formatting Top/Bottom Rules, set color coding, then publish to PA Workspace.

If you need to do this in PA Workspace natively, I haven't found the same capability. But, you can create a calculation, use rank, then set conditional formatting to something like 'yourcolumn >= value 10' to color code the top 10. Of course, you can hide the calculated column.
See the screen for a sample highlighting top 5 with green and bottom 5 with red.

------------------------------
Tom Kim

Original Message:
Sent: Thu September 19, 2019 01:14 PM
From: Dhwani Talsania
Subject: Workspace : how to do a top 10 and bottom 10 variance by account

​Hi all

I am trying to create reports in workspace am fairly new to the IBM PA and taking a course on data and creating report.

However the training module does not give any idea on how to do conditional formatting with regards to getting  top 10 and bottom 10 variance by account and highlight the same.

Any input will be super helpful.

TIA

------------------------------
Dhwani Talsania
------------------------------

#PlanningAnalyticswithWatson

Hi,

In PA Workspace, you can highlight the column you want to use in ranking. Right-click on the column name and select Top or Bottom Filter.

Thanks,
JolM

------------------------------
Joelito Mendoza
------------------------------

Original Message:
Sent: Fri September 20, 2019 12:57 PM
From: Tom Kim
Subject: Workspace : how to do a top 10 and bottom 10 variance by account

Hi Dhwani,

You can use PA for Excel, leverage conditional formatting Top/Bottom Rules, set color coding, then publish to PA Workspace.

If you need to do this in PA Workspace natively, I haven't found the same capability. But, you can create a calculation, use rank, then set conditional formatting to something like 'yourcolumn >= value 10' to color code the top 10. Of course, you can hide the calculated column.
See the screen for a sample highlighting top 5 with green and bottom 5 with red.

------------------------------
Tom Kim

Original Message:
Sent: Thu September 19, 2019 01:14 PM
From: Dhwani Talsania
Subject: Workspace : how to do a top 10 and bottom 10 variance by account

​Hi all

I am trying to create reports in workspace am fairly new to the IBM PA and taking a course on data and creating report.

However the training module does not give any idea on how to do conditional formatting with regards to getting  top 10 and bottom 10 variance by account and highlight the same.

Any input will be super helpful.

TIA

------------------------------
Dhwani Talsania
------------------------------

#PlanningAnalyticswithWatson