Hello,
Actually I am creating a Bar chart where in X axis I have Week Number and Y axis I have Forcasted Terms measure. Now I need to color code this bar graph based on Probability Value, ie If Probability is <30 then one color and if its between 30 and 70 then one color and if its >70 then another color.
Here All the measure names like, probability and Forcased terms are appearing as records in my dataset based on the requirement to get the values at different aggregated levels. For each measure I have Different aggregations which are precalculated from db side. So Im using the below calculation to derive
Probability : avgIf({measures},{retention_metric_name}=‘probability’)*100
Since we have all the measure values in single column, we are extracting that measure (eg: Probability) in quicksight using the metric name dimension. This structure is based on our specific requirement.
When I created a calculation to color code it based on conditions,its showing that since we are using aggergated functions i cannot make it as dimension
Color =
ifelse(
Probability<=30,‘Low’,
Probability>30 and Probability<=70,‘Medium’,
Probability>70,‘High’,‘Others’
)
Can anyone please help, how can I make this field to place in Color shelf?
