Color expression for a complex dimension

[ckiesling]

This is my color expression, but I cannot get it to work.

=IF(
[Client Hospitalizations.Follow Up Contact Date] <= ([Client Hospitalizations.Discharge Date] + 3),
rgb(239, 61, 65)
,
rgb(39, 38, 66)

)

[MeehyeOh]

Hi, @ckiesling 

You Mean this?

-Sample data

-Color expression

First of all, Is [Client Hospitalizations.Follow Up Contact Date] and [Client Hospitalizations.Discharge Date] date type?

Second of all, What kind chart do you use and there's Client Hospitalizations dimension?

please reply! thanks!

[ckiesling]

Yes, both [Client Hospitalizations.Follow Up Contact Date] and [Client Hospitalizations.Discharge Date] are date type.

I'm trying to make a stacked bar chart.

Group:

=if([Client Hospitalizations.Followup Contact Type Code Display Name]='Face-To-Face' OR [Client Hospitalizations.Followup Contact Type Code Display Name] = 'Phone' , 'Yes','No')

Bars:

=IF(
[Client Hospitalizations.Followup Contact Type Code Display Name]='Phone' OR
[Client Hospitalizations.Followup Contact Type Code Display Name]='Face-To-Face'AND
[Client Hospitalizations.Follow Up Contact Date]<=([Client Hospitalizations.Discharge Date]+3),
'Yes',
'No'
)

Measure:

count(distinct[Client Hospitalizations.Hospitalization Event Key])

[MeehyeOh]

Hi, @ckiesling 

How about this?

Group
=ValueList('Meet','Not_Meet')

bar

=ValueList('Yes','No')

Value

=Pick(Match(Valuelist('Meet','Not_Meet'),'Meet','Not_Meet')
, Pick(Match(Valuelist('Yes','No'),'Yes','No')
,Count(Distinct {< Followup_Contact_Type_Code_Display_Name = {'Phone','Face-To-Face'}, Diff = {"<=3"}>} Client_Hospitalizations)
,Count(Distinct {< Followup_Contact_Type_Code_Display_Name = {'Phone','Face-To-Face'}, Diff = {">3"}>} Client_Hospitalizations))
, Pick(Match(Valuelist('Yes','No'),'Yes','No')
, Count(Distinct {< Followup_Contact_Type_Code_Display_Name -= {'Phone','Face-To-Face'}>} Client_Hospitalizations)
, Null()))

Color

* Chart suggestions - Appearance - Color and legend - Colors : Custom & By expression

Expression
=Pick(Match(Valuelist('Meet','Not_Meet'),'Meet','Not_Meet')
, Pick(Match(Valuelist('Yes','No'),'Yes','No'),rgb(239, 61, 65),rgb(39, 38, 66))
, Pick(Match(Valuelist('Yes','No'),'Yes','No'), rgb(39, 38, 66), Null()))

Please reply! thanks!