Aggregated calculations are not able to use as Dimension

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?

Hi @Ganga,
As you already mentioned, calculated fields are always measures and cannot be changed to be a dimension. However, I made a suggestion on your other question and hope that this solves your use case.

Did this answer your question? If so, please help the community out by marking this answer as "Solution!

1 Like

Hi @Ganga, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!