7 Replies Latest reply on Jun 10, 2018 7:46 PM by Bryce Larsen

Trying to achieve up and down arrow

Grace Raj Jun 8, 2018 4:23 PM

Friends,

I am trying to achieve this format, For example, anything more than equal to 3 , the text should be in red color and show up indicator with red..

Category	Number	Indicator
A	189	↓
B	53453	↑
C	39434	↑
D	100	↓
E	201	↑
F	45	↓
G	200	↑

I am getting only one legend which is UP arrow , not seeing Down arrow for some reason. Also I am getting the only one shape legend,

step 1: created calculated field with below formula

if [A] >= 200 then "⬆" ELSE "⬇" END

step 2: drag the calculated field into color in the MArk area

step 3: change the Mark into Shape

Step 4: Drag the same calculated field into shapes in the MArk area

I am getting like this , I am not seeing down arrow ..

I tried all the link.. but wouldn't achieve this. Appreciate your help

Thanks

Grace

1. Re: Trying to achieve up and down arrow

Deepak Rai Jun 8, 2018 5:01 PM (in response to Grace Raj)

What do you mean by More than Equal to 3?
Like Show 0 Likes(0)

Actions
2. Re: Trying to achieve up and down arrow

Grace Raj Jun 8, 2018 6:22 PM (in response to Deepak Rai)

Sorry.. , ignore this condition , " More than Equal to 3?" I should have
put in this way

If >= 200, then up else down end

On Fri, Jun 8, 2018 at 5:02 PM, Deepak Rai <tableaucommunity@tableau.com>
Like Show 0 Likes(0)

Actions
3. Re: Trying to achieve up and down arrow

Bryce Larsen Jun 8, 2018 6:19 PM (in response to Grace Raj)

Hi Grace,
I think you want to only put this into the the Text pane as this looks like what is done in the example. If you actually want it to be a shape, can you post screenshot of the Shape legend?

Here's example of Superstore:
Best,
Bryce
Like Show 0 Likes(0)

Actions
4. Re: Trying to achieve up and down arrow

Grace Raj Jun 9, 2018 1:16 AM (in response to Bryce Larsen)

Hi Bryce

Thanks ...I got 2 shape legends after i put SUM in the calculated field, but the shapes are overlapping on the measure and I need to get towards right side like you showed in your screenshot....How do I get it

Thanks
Grace
Like Show 0 Likes(0)

Actions
5. Re: Trying to achieve up and down arrow

Bryce Larsen Jun 9, 2018 9:14 AM (in response to Grace Raj)

Hi Grace,
Just need to put SUM([Measure]) in the Rows shelf and make discrete. Then change the graph type from Automatic to Shapes. That should be it! Highlighted here:
Like Show 0 Likes(0)

Actions
6. Re: Trying to achieve up and down arrow

Grace Raj Jun 10, 2018 2:04 PM (in response to Bryce Larsen)

Thanks! Bryce.. Yes, after I applied SUM and Discrete, I got the expected view, is it possible to apply same color to the text as well ..I tried applying the "Arrow-Calculated field" into Color - Mark.. I wouldn't get it... Or we can't achieve this in both both column..
Please advise me..
Like Show 0 Likes(0)

Actions
7. Re: Trying to achieve up and down arrow

Bryce Larsen Jun 10, 2018 7:46 PM (in response to Grace Raj)

Hi Grace,
My suggestion would be to put both in the Text pane instead. Make separate fields for Arrow up and Arrow down and place both in the text pane and color accordingly. Likewise, do the same for the raw number.
Hope this helps!
Like Show 0 Likes(0)

Actions