This content has been marked as final. Show 2 replies
I'm loading dimension from the database, dimension is a date value. I'm using following formula to change to 'MMM-YY', also shwon in the below image. =Date(monthstart(D_CREATE_DATE), 'MMM-YY')
I'm having trouble to change the bar color for Mar-17.
I'm using color by expression and using following formula, but I'm not able to change to color to green for dimension value of 'Mar-17'
=If(Date(monthstart(D_CREATE_DATE), 'MMM-YY') = 'Mar-17', Green(), Red())
Any help is appreciated.