Hi team,
Is there a way to create a stacked bar chart that goes to 100%; i.e. showing the % split of records instead of simply the absolute count of records.
I have this chart to roughly measure conversion rate from various sources;
![Screenshot 2021-05-03 112835 Screenshot 2021-05-03 112835](/t5/image/serverpage/image-id/20130i4AC9B15F63F567DB/image-size/large?v=v2&px=999)
But it would be even better if each bar extended to 100% and instead showed the percentage of records from each source that either booked or were lost.
![Screenshot 2021-05-03 112835b Screenshot 2021-05-03 112835b](/t5/image/serverpage/image-id/20139i25A2C68E3B15CB7E/image-size/large?v=v2&px=999)
Is it possible to create something like this; either by manipulating the data via formula, or with a chart/app option that I’m missing?