tableau - 如何在单个图表中获得三个度量？(How to get three measures in a single chart?)

Question

I want three measures in a single chart.

(我希望在单个图表中包含三个度量。)

1. Time spent by an employee in the office.

   (员工在办公室花费的时间。)

   (Available hours)

   (（可用时间）)

2. Time spent by an employee on productive tools.

   (员工在生产工具上花费的时间。)

   (Productive Hours)

   (（生产时间）)

3. Percentage of time spent productively.

   (用于生产的时间百分比。)

   (PH : AH %)

   (（PH：AH％）)

I have used dual axis for 1 and 2 as 2 will always be less than 1.

(我将双轴用于1和2，因为2总是小于1。)

I want it to look something like this

(我希望它看起来像这样)

The problem is when I use blended axis it does not show the "tools hours" as a part of "available hours".

(问题是当我使用混合轴时，它没有将“工具小时数”显示为“可用小时数”的一部分。)

So for example if an employee was available for 5 hours out of which he worked on productive tools for 3 hours the blended axis will show total available hours to be 8.

(因此，例如，如果某个雇员有5个小时的空闲时间，而他在生产工具上工作了3个小时，则混合轴将显示总可用时间为8。)

  ask by Vinamra Bali translate from so

Answer 1

等待大神答复