Hi @Ganga,
You can achieve the desired behavior by creating a calculated field for each condition (Low, Medium, High) and then adding each field as a value to a stacked bar chart and picking the color for each condition, by selecting it in the legend.
Here is a quick example, in which we color the bar differently depending on the number of records by month within the dataset:
Let’s say you define 3 calculated fields such as
- low_bucket:
ifelse(count(Customer)<=100,count(Customer),0) - mid_bucket:
ifelse(count(Customer)>100 AND count(Customer)<=200,count(Customer),0) - high_bucket:
ifelse(count(Customer)>200,count(Customer),0)
In the following screenshot you can see the difference between using the regular count by month on the right side vs the colored count using the calculated fields on the left side:
Did this answer your question? If so, please help the community out by marking this answer as "Solution!