Sum Two Segments in Bar Chart

Question & Answer
, ,
1

I have a bar chart that has dynamic number of segments. Chart itself is working as expected.

New requirement is to add two segments together, ComputeSavingsPlans+AmazonEC2, for a new segment and hide the individuals. How can I accomplish this at chart creation time? I would rather not have to go back to raw data and try and accomplish this if at all possible.

See screenshot for example of bar chart I currently have configured.

barchart
barchart1648×745 42.6 KB

2

Hi @jackattack6800,

You can create a calculated field in the analysis to do the encoding of the existing field value. An if else with coercing both values to new segment name should work. And use the new field in the visual instead of the existing one.

Sample field :
ifelse(segment=“segment1”, “new segment”,
segment=“segment2”,“new segment”, segment)

Thanks,
Prantika