5 Replies Latest reply on Aug 26, 2013 9:02 AM by Matt Lutton

# Graphics with target

Hi Everyone.

I need to make a graph similar to the attached. Where each of the variables are measured, and according to a target different for each measured, gap is obtained for difference between target and operation.

In Tableu, I could make the first bars of the percentage obtained in the operation. but i have issue with  target value which is different for each of the measures and color the gap in the graph

• ###### 1. Re: Graphics with target

If you are willing to invest just a short amount of time reading the above document, I am willing to personally make sure your question gets answered. Deal?

Great!

--Shawn

1 of 1 people found this helpful
• ###### 2. Re: Re: Graphics with target

Hi Shawn, Thanks your recommendation. I

I want to do is the following:

1. I have calculated  13 variables  and I have used that in the graph shown in the attachment workbook.  I made this in the calculated variables

SUM([a15]) / TOTAL(SUM([Número de registros])), because I need to known the percent in function this variable and I do not need the percent of total row or total column.

2. I want to make a KPI in this graph.  I would like assign for each variables a target for achieving. For example: The variable "a16" (view attach workbook)  have 11.78% but mi target is 30%  and the gap is the 18.22% . How to do this?

Can you help with this.

• ###### 3. Re: Graphics with target

Hey Mery and welcome to the forums!

KPIs can be easily created with Calculated Fields, if you want the targets to be static.  If you want them to be dynamic, or user-controlled, you will want to use parameters.  If you are not familiar with either of these concepts, there are several great training videos (both by Tableau, and by others on YouTube, etc) demonstrating how these work.

• ###### 4. Re: Re: Graphics with target

Hi Matthew

Thanks.

Sorry, I attach the workbook again.

Maybe, KPSs can be easily but I have problems in this workbook because I want the target for each variables and I do not how to do.

• ###### 5. Re: Re: Graphics with target

You can just write calculated fields, like "A16 target".  That calculation can either be something like "A16*1.15" or if you want a static number like 30% in your example, just type .3 in the calculation, and you know have the target value as a measure.  And, again, you can create parameters so that users can input the target value themselves to see comparisons that way.

Creating the stacked bars is a different matter--I'm not very experienced with using KPIs in this way, so perhaps someone else can help there. It seems that typically, a stacked bar is creating by placing a dimension on the color shelf, and I'm not sure that applies to your situation (maybe Measure Names on the color shelf would work depending on your setup)

One thing is for sure--comparing measures is perfectly doable in Tableau, it just takes time to learn how things operate within the software.

This may be helpful reading as well: Budgets Vs Actuals – part I - The Information Lab