7 Replies Latest reply on Aug 20, 2018 5:25 PM by Sushmitha Reddy

# Adding a square or a vertical line in the back of the graph

Hey guys i have the next requeriment in my current project. I need to show the information of SLA dates of different stages in a credit like the next image

The issue is that the x axis is a discrete dimension with strings as values ('Ingreso de Operaciones', 'En Proceso', etc.)

And in the y axis are the count of registers. I need to add a - like the image - square or a vertical line that can define the limit SLA stage of the credit, the stages are the values in the x axis ('Ingreso de Operaciones', 'En Proceso', etc.), i'm attaching the .twbx document with the example of what i have till now, but is only the lines but nothing in the back,

I hope i made myself understand. Thanks

Robertino,

• ###### 1. Re: Adding a square or a vertical line in the back of the graph

Are you looking for something in this manner? Wasn't sure of the question but took a shot at it:

Attached is the workbook with solution. IF you find it helpful then please mark it accordingly. Thank you.

• ###### 2. Re: Adding a square or a vertical line in the back of the graph

Hi Ankit, no, what I'm looking for, as the image I put in the post, is to show behind the lines a box or a square of another color in which the position of that line or the line of the square is one of the stages of the credit. As shown in the picture with the grey colour behind the lines

Thanks, Robertino

• ###### 3. Re: Adding a square or a vertical line in the back of the graph

This time with attached workbook - Adding a Box via the option of Reference Line

• ###### 4. Re: Adding a square or a vertical line in the back of the graph

Hello Ankit, it's a good solution BUT what if I want the box to go to its maximum value and the maximum stage is another and not the one without data? As if the box had as its maximum stage the "Pago de Impuesto" stage, is it possible?

Something like this (sorry for the bad image haha)

Thank you, Robertino.

• ###### 5. Re: Adding a square or a vertical line in the back of the graph

Hi Robertino,

I was able to mimic the view in your screenshot in tableau.

For that, I created a calculation field using INDEX() to separate the first four Stages from the x axis. Now, that creates a new measure, you can drop that on the column and dual axis with Register Count. You can change the width of the background box by increasing/ decreasing the relative Index number in the SLA calculation.

Change the mark type for the SLA either to Bar or Area and set the size to maximum. That will give you the shading in the background.

Attaching the workbook here.

1 of 1 people found this helpful
• ###### 6. Re: Adding a square or a vertical line in the back of the graph

Thank you Sushmitha!! Thank you very much!