Colorcoding cells with multiple values

[nicolai_moller]

Hi

I have a situation with colorcoded cells, where I want to color the cell of activitities depending on the status of the activity.

Each activity is related to a case, where a case can have multiple activities and multiple of the same activity.

In the attached document, case 1 have activity A two times, but with different status (postponed and done).

But neither of them receives a color in the chart, so it looks like none of the activities exists.

Shouldn't at least one of the colors show up in the chart, or do any of you have a another solution to this.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

You'll have to use an aggregation function. For example

if(max(Status_Flg) = 1, blue(),

if(max(Status_Flg) = 2, green(),

if(max(Status_Flg) = 3, yellow(),

if(max(Status_Flg) = 4, brown(),

if(max(Status_Flg) = 5, black(),

if(max(Status_Flg) = 6, rgb(192,192,192)))))))

Otherwise the only() function is used and that will return a null if there is more than one value for the combination of dimensions. This is the case for Case 1 - Activity A.