ssheffer77

Thank you, I see what happen. Your response answered my question.

in Card - Display as Quick Filter "New Values" Comment by ssheffer77 July 18

@MarkSnodgrass thank you. I created the variable and used a case to retrieved expected results.

in Chart Quick Filter to Change which Measure is pulled into Bar Chart Comment by ssheffer77 February 5

This worked: case when replace(Date,'00:00:00','') like '%-%' Then replace(Date,'00:00:00','') else 'No Date' End Applied Color Rule on the Beast Mode above on No Date and was able to highlight my missing date cells. The nulls have "No Date" vs a blank however should not be a problem for my scenario.

in Conditional Formatting on a Date in a Card Table Comment by ssheffer77 November 2023

@GrantSmith I tired different beast mode functions with the color rules and so far each attempt is not allowing a condition on "missing date" but still working on this one to see if anything will work.

in Conditional Formatting on a Date in a Card Table Comment by ssheffer77 November 2023

@MichelleH I tried the below with attempt to apply a Color Rule on "No Dates" however the condition wants to still have date logic used. CASE WHEN ifnull(Date Proposal Sent,0)=0 THEN 'No Date' Else Date Proposal Sent End Trying to play around with this one but no luck either (I would still need to add correct color to the…

in Conditional Formatting on a Date in a Card Table Comment by ssheffer77 November 2023

ssheffer77 Member

Comments