Coloring of bar chart based on custom aggregated field

Question & Answer
, , ,
1

Hi Team,

I have a query regarding the coloring the bar chart as per a threshold. I have a data which contains initial data and final data, I need to see how much it has changed over a time.
For example, I have a physical training program going on and I need to see how much average weight my clients have lost over the months, calculation for it would be like:

Weight difference = {initial_weight} - {final_weight}
Weight lost = sumIf({Weight Difference},{Weight Difference}>0)
Average Weight = {Weight Lost} /count(participant)

Here I want to segregate the bar colors based on if my ‘Average Weight’ has met a threshold set i.e. ifelse({Average Weight} >= 5, ‘Green’, ‘Red’).
While I know Average Weight is an aggregated field, I have tried a number of ways to deal with it and also looked here, but to no avail.
Can this please be helped?

Regards,

2

Hey @HimaniS ,

I don’t think is possible yet. It seem like you need a conditional formatting for Bar Charts, like its mentioned here: Conditional Formatting: Bar Graphs & Line Charts - Question & Answer - Amazon QuickSight Community. Maybe using a table or another visual with Conditional formatting on visual types in QuickSight - Amazon QuickSight could help you.

BR
Robert

3

Hey @robert.eibers,

Thanks a lot for your response.
Yes, it seems it’s not possible as of now and we probably have to wait for this feature. And sure, we’ll see if we can alter the visualization there or think of a work-around for the time being, nonetheless.

Thanks a lot!
Regards,
Himani