11 Replies Latest reply on Dec 8, 2018 7:13 AM by Tony R

# Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

I want the appropriate arrow to display when the pivot field value has increased "▲", decreased "▼", or stayed the same "►"

I have been playing around with each different "compute using" selection all today trying to get the number "4" to display "4"  Exactly like how Actual Gaps Closed "1" looks like.

I am at a stand still and banging my head over this that I am hoping someone in the community understands what I am trying to accomplish and can direct me in the solution.  Hoping for an S.O.S.

Edit Table Calculation Box for Decrease (Arrow) and Increase (Arrow) look identical to the Equal (Arrow) shown below.

• ###### 1. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Hi Candace,

For the equal sign, maybe you could use the calculation such as :

if ZN(SUM([Pivot Field Values])) = LOOKUP(ZN(SUM([Pivot Field Values])), -1)]

then ''

end

Because your current equal sign calculation is nesting the other table calculations right now. So the above may be cleaner.

Thanks,

Mavis

• ###### 2. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Hi Mavis, I was eager to try out the different formula yet its still giving me issues and acting the same way.  The table calculations for Decrease and Increase (Arrows) look identical to the Equal calculation below.

What I am trying to accomplish is to show if on 10/12 Actual Gaps Closed  OR Gaps Needed = 10/19 Actual Gaps Closed OR Gaps Needed then show Pivot Field Value with respectable arrow.

You have any other suggestions?!

• ###### 3. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Candace,

I made an attempt to mock up your setup. I didn't get it right, would be grateful if you'd

please adjust attached workbook and dataset to more closely match yours and then repost.

I also didn't replicate your equals calculation, so maybe the below won't work.

But it feels to me that it comes down to the Table Calculations settings.

I didn't see a restart on Pivot Field Names (maybe you renamed it?)

Please see workbook v10.3 and dataset attached in the Forum Thread:

Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

1 of 1 people found this helpful
• ###### 4. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Hello, I switched out the calculations to the ones your report showed for sanity sake.  I love that your workbook is functioning as I need   However, when I try to replicate it on the my report, it won't provide me with the Pivot Name Field as a drop down option for "restarting every". I have attached the spreadsheet you sent with some added data and images. Not certain why it is not showing that as an option.

• ###### 5. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Hi Candace,

Looks like Pivot Field Names it not on your rows shelf.

Thanks,

Mavis

• ###### 6. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Candace,

You can drag and rearrange the order of the selections in the Specific Dimensions box.

If you move Pivot Field Names up, it will become a selection in the "Restarting every" drop down.

It doesn't necessarily have to be the topmost position, but it can't be the lowest position.

• ###### 7. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

I included Pivot Field Names into my rows I replicated everything even where the dimensions lay in the table calculation and it still won't populate appropriately. Formulas match up to the tableau mock up listed above.

• ###### 8. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Silly me (face palm) I formatted the numbers to be whole # so even in setting up the correct calculations as you all provided tableau still was saying no you did in face increased.  I plan to change the format to the below so it makes sense to the end user. I'm gonna grab myself another cup of coffee. I appreciate you both for helping me on this.

• ###### 9. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Candace,

Good catch, I didn't think of that.

Glad you got it working.

All the best.

• ###### 10. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

Candace,

That brings up a good point.

Depending on how many decimal points are in your data,

you may want to make all the comparisons off of a rounded value as well.

If, for example, one month is 1.004 and the next month is 1.003,

it will show a down arrow, but the label will just show "1.00" and "1.00".

• ###### 11. Re: Bar Chart Table Calculation increased "▲", decreased "▼", or stayed the same "►"

How were you able to color the triangles without using color mark card? i'm trying to accomplish something similar and wondering if it would work for my project.