Tableau stacked side-by-side bars with two different dimensions splitting the columns

Question

I am trying to create a stacked side-by-side bar chart over time with 2 measures:

• Total Calls (Split by type of a call)
• Requests (Split by type of a request)

I have reached a point where I can get this view:

I'm having trouble getting the 'Calls' bar to be coloured by the call type, and Requests to be coloured by its own type, so that I can obtain this:

(purple colors: types of calls, red-orange-blue colors: types of requests.

Answer 1

Use a single axis instead of a dual axis. Instead, set [Measure Values] aside and limit your measurements to Requests and Calls. This should provide the desired stacked side-by-side look.

If your data is organised so that each row level record is either a call or a request, you can construct a calculated field that utilises the proper colour dimension based on whether the record is a call or a request to get the colours correct.

If ISNULL([Call]) THEN [Request Type] ELSE [Call Type]

If your request and call measure are both in the same row level record, you'll have to utilise a combined dimension on the colour shelf.