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

0 votes

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:

image

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:

expected outcome

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

Mar 16 in Tableau by Vaani
• 5,040 points
18 views

1 answer to this question.

0 votes

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.

answered Mar 22 by Neha
• 6,260 points

Related Questions In Tableau

0 votes
1 answer

Stacked side by side bars with two different dimensions splitting the columns.

Hi, to split the columns using 2 dimensions/measures/combination in ...READ MORE

answered Mar 4, 2019 in Tableau by Cherukuri
• 33,010 points

edited Mar 4, 2019 by Cherukuri 322 views
0 votes
0 answers

Tableau stacked and side-by-side bar chart on column aggregation

I have a data set like this Name ...READ MORE

Mar 31 in Tableau by Vaani
• 5,040 points
39 views
0 votes
0 answers

Issues with the Tableau server extracts

A tableau developer had successfully created dashboard ...READ MORE

Apr 21, 2018 in Tableau by Atul
• 10,230 points
349 views
0 votes
1 answer

Issues with the Range value in Tableau

One of the best solution is to ...READ MORE

answered May 9, 2018 in Tableau by sdfg
• 5,550 points
687 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
47 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
65 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
32 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
70 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP