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:
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |