Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
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!
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])
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!