100% Stacked Bar Graph per client showing work hours and travel hours relation

Cannot find how to do this: is it possible to sum up all the travel hours (separate field) and work hours (separate field) per client (separate field, can be filtered using slice) and displaying a graph in the dashboard showing a stacked bar chart (100%) to show the ratio?

In Excel this would look like:
2X_9_9471e3c4c1f6d5272c958aa220bd0f0b0dbc50d5.jpeg

0 1 431
1 REPLY 1

Yes there is a stacked bar chart option (col series(stacked)). You will need to calculate the percentages yourself in two separate columns ([col1] / ([col1]+[col2])), then select those percentage columns for the chart as shown in the screenshot where I have โ€œlabor rateโ€ and โ€œ_rownumberโ€ selected.

Top Labels in this Space