Stacked area chart by ratio

Question & Answer
1

Hi,

I would like to know if there is a way to create a stacked area chart that is added up to 100% and each category on this chart will get a ratio in accordance to its portion.
I attached an image of example to this kind of chart.

stacked_bar_chart_by_ratio
stacked_bar_chart_by_ratio733×395 13.4 KB

2

Hi,

Thanks for reaching out. QuickSight can do this with the column chart, but not currently with the Area chart. We will take a look at this for a future release.

Best,
Sean

3

Is this calc a workaround for now?

count({requests_info_nte_and_sme})
/
sumOver(count({requests_info_nte_and_sme}), [day])

requests_info_nte_and_sme is my category

1 Like
4

This worked for me. In my situation this was my calculated field:

{endpoint_distinct_count}
/
sumOver({endpoint_distinct_count}, [{date_drill_down}])

I then created a stacked area line chart and set missing data to show as 0.