7 Replies Latest reply on Sep 13, 2018 9:22 AM by Shinichiro Murakami

# Table Calculations issue: break in % difference indicative of over all issue

This is  an issue effecting my dashboard

Issue: Table calculation breaking and then resetting, undesired.

I have checked the data and there are no missing values,  maybe its and issue with the order of the months or there format.  This error effects the table calc % diff and the running 12 month.  Its like the record before it does not exist and so it stop and restarts calculation

• ###### 1. Re: Table Calculations issue: break in % difference indicative of over all issue

For all three table calc, you need to check bottom dimension as well.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Table Calculations issue: break in % difference indicative of over all issue

Hi Marc,

What does the % difference calculate? Is it the % difference of  'U1.Idrcount' along U1_Year and Month/Year? If yes then the numbers seem wrong.

For example, between 201501 and 201502, %diff should be -9.74% and not -8.87%.

(4148438 - 3780335)/3780335

If that is what you are looking for then, I have created separate calculations for the columns.

[% Diff]

IF  FIRST() != 0 THEN

ZN((LOOKUP(SUM([_U1.Idrcount]),0) - LOOKUP(SUM([_U1.Idrcount]), -1)) / LOOKUP(SUM([_U1.Idrcount]),0))

END

Hope this helps.

Ossai

1 of 1 people found this helpful
• ###### 3. Re: Table Calculations issue: break in % difference indicative of over all issue

is this the case with all table calcs if you want it to go all the way down the table it must be clicked on all three...?

• ###### 4. Re: Table Calculations issue: break in % difference indicative of over all issue

Thanks Why is it doing that? seems like clear intent with unclear outcome.

• ###### 5. Re: Table Calculations issue: break in % difference indicative of over all issue

HI Marc,

Table calculation is the most difficult function in Tableau from my experience.

It 100% depends on each table structure and especially add complications and troublesome tasks once you set table calc then, you add/remove dimensions.

Every time you change the table structure, non-simple-table-calc is easily broken. sometimes without any error message....

Thanks,

Shin

1 of 1 people found this helpful
• ###### 6. Re: Table Calculations issue: break in % difference indicative of over all issue

Shinichiro,

This helped me. now i understand better thank you

• ###### 7. Re: Table Calculations issue: break in % difference indicative of over all issue

Sounds good.

Keep learning.

Shin