Ranking across a dimension consisting of multiple list items

Occasional Contributor

Ranking across a dimension consisting of multiple list items

Hello,

I'm trying to create a sort of 'heat map' based on percentages within columns in a table.

Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting.

For example, 'training period' would have 'problems with solute/water clearance' and 'peritoneal leaks/hernia' as the deepest color red because they’re the highest percentages within that column and then everything from there would be gradually shaded less and less depending on what the percentage is.

The problem is, I want this to happen within each column - not across the entire table. I have been trying to formulate some type of rank formula but each column is representative of a different member in a list so it's a bit difficult.

Has anyone performed something similar?

Any type of help would be much appreciated! Thanks!

4 REPLIES 4
Moderator

Re: Ranking across a dimension consisting of multiple list items

Are you saying that you want to format line items based on their list items or percentages of their list items. For Example Training period Line item has

Solute Water Clearance - that should be deep red

Hernia or something - Deep red

Less Hernia - Amber

Least Hernia - Yellow

If the understanding is not right please share the mock up for this? (excel would do).

Misbah

Occasional Contributor

Re: Ranking across a dimension consisting of multiple list items

@Misbah  yes exactly -

From red to yellow to green based off of the percentages like the picture I have attached

Moderator

Re: Ranking across a dimension consisting of multiple list items

Yes, conditional formatting is applied on the line item and is not applied on list item level. Having said that if your list is a structural list probably this kind of heat map can be created. Assuming your list is a structural list

First Create a Line item Subset (LIS) based on the line items that you have in current module

Insert one line item  for every list item

Use COLLECT() to pull the values

Format your line items based on the logic

Misbah

Occasional Contributor

Re: Ranking across a dimension consisting of multiple list items

@Misbah hey -

Can you specify what you mean by structural list?

Thanks!