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, 2022 in Tableau by Vaani
• 7,070 points
923 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, 2022 by Neha
• 9,020 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,030 points

edited Mar 4, 2019 by Cherukuri 938 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, 2022 in Tableau by Vaani
• 7,070 points
770 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,240 points
682 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 ffdfd
• 5,550 points
1,202 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, 2022 in Tableau by Vaani
• 7,070 points
491 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
441 views
0 votes
0 answers

Tableau Map view Continent List

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
561 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, 2022 in Tableau by Vaani
• 7,070 points
573 views
0 votes
1 answer
0 votes
1 answer

What is the best middleware for the following architecture ? (Logs, ELK, Tableau)

It appears that you'll need an ETL ...READ MORE

answered Mar 14, 2022 in Tableau by Neha
• 9,020 points
595 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP