Does anyone know I can change color of a chart or not?
Because I would like to show always same color each groups.
Group A - Blue
Group B - Red
Group C - Green
Even there is no data for group B, I prefer not to change the color.
I have a formula field named Contract End Date and the value of this field should be calucated based on Contract Start Date and the Contract Duration. Contract Start Date is of type Date and Contract Duration is the number of months. Id I just add both the fields it considers Contract Duration as number of days instead of month. How do I achieve this?