0 votes
1 view
in BI by (17.6k points)

We test people and then provide analysis for managers and HR teams. I have a chart that I created in Excel which I am struggling (as a novice) to recreate in Tableau.

Competency slider

I started with bullet charts but the problem I had with that is that the bands were relative to the target value and I couldn't see a way to link them to variables. Also, the bands don't always go from red to green. There are some attributes where the test may be looking for balance rather than an extreme (e.g. perfectionism).

Instead, I went the route of stacked bar charts to show a red, yellow, green type of analysis. I have managed to create a stacked bar chart in Tableau but I can't overlay a marker to show the individual's performance. This is how my data is currently:

Data for Tableau slider

When I try to overlay the Score on the stacked BandLimit I get this which is not what I'm after: 

Tableau effort at a slider

What am I doing wrong? I would love to know how I could fix this but also if there are other ways I could do this (bullet chart, etc.) and any tips you might have on better ways to display the information.


1 Answer

0 votes
by (47.2k points)

  • If you want to add the arrow that you had in the Excel bullet chart. We can do that with a second mark. I'll go ahead and include your steps so far, just to make sure everyone's on the same page:

  • Place Competency on the Rows shelf.

  • Place SUM(Band Limit) in the Columns shelf.

  • Place Band in Color.

  • Now we'll make a new mark to get that arrow onto the viz. Score needs to be placed in the Columns shelf, after SUM(Band Limit). We need to right-click on the Score pill and make it a dimension, but keep it continuous. Lots of things will likely change automagically, but no worries, we'll get it back under control in a minute. One important thing to note is that there are now two marks shown in the Marks Card - one for SUM(Band Limit) and one for Score.

  • Right-click the Score axis and hit Dual Axis. Then right-click the Score Axis again (which is now at the top of the view) and hit Synchronize Axis. You should now have an axis at the top and bottom of the view, and they should be aligned with one another.

  • Go to the SUM(Band Limit) section in the Marks card. Make sure the only thing in Color is Band, then change the mark type to Bar. You should wind up with stacked bar charts again.

  • You need to go to the Score section on the Marks card. You'll probably want all of your arrows to be the same color, so take everything out of Color. Click Color and choose black (or whatever feels right to you).

  •  Change the chart type in the Score section in the Marks card, Now choose the Shape and select an arrow for the shape to replicate the Excel chart. Gantt Bar can also be chosen to have a thin black line instead of an arrow.

  • Right-click on axes and uncheck Show Header if you don't want them there. If you opt to remove both of them, make sure you include some way to see the values, maybe with a tooltip or by creating labels for one or both marks.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 29, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !