
1. Re: sheet calculation median and table calculated median do not match
Joost Valk Nov 14, 2018 7:08 AM (in response to Joost Valk)Nobody has a solution? Or experienced the same problem?

2. Re: sheet calculation median and table calculated median do not match
Don Wise Nov 14, 2018 8:30 AM (in response to Joost Valk)Hello Joost,
Just looking at your data for (median) EBITDA (Earnings Before Interest Taxes Depreciation & Amortization). Those values are straight from your data source and not a calculation. Your next median value is EBIT, which is quite a bit different from EBITDA in that it doesn't take into account Depreciation & Amortization. So those values will also be significantly different from EBITDA (median). I would not have the expectation that they'd be the same.
For (median) EBITDA in your Dashboard and your worksheet I'm seeing 11.56X for both.
If you're saying the quantity between EBIT and EBITDA should be the same, in looking at your data row by row there are significantly more EBIT values than EBITDA values, which are straight from your data source, not a calculation.
Or am I not understanding the question?
Thanks Don
Values are the same between worksheet and dashboard

3. Re: sheet calculation median and table calculated median do not match
Joost Valk Nov 14, 2018 8:55 AM (in response to Don Wise)Hello Don,
Thanks for the response. I guess I did not formulate my question clear enough. In my dashboard you can see a table showing the median both for the EBITDA en EBIT median multiples. On the top of my dashboard you see the median EBITDA and EBIT median multiples, but calculated not in the table but from the data source directly. Since I have no filters active the table calculation and the calculation directly from the data set should give me the same result, but they don't. So to clearify, the table calculation gives me a median of 11,20 and the calculation directly from the data set gives me 11.56. So my question is why they do not match and how to fix it.

4. Re: sheet calculation median and table calculated median do not match
Joost Valk Nov 14, 2018 8:58 AM (in response to Joost Valk)the median of the EBITDA multiple is mend in the second last sentence

5. Re: sheet calculation median and table calculated median do not match
Michael Gillespie Nov 14, 2018 9:15 AM (in response to Joost Valk)Joost, for the 11.56 value, you are including ALL countries (Target Dominant Country action filter set to "Use All")
For the 11.20 value, you are NOT including all countries (Target Dominant Country filter manually set to exclude several countries).
However, including ALL countries lowers the 11.20 value to 11.17 so something else is going on.
It's possible that the NULL values are skewing the calculation.

6. Re: sheet calculation median and table calculated median do not match
Joost Valk Nov 15, 2018 12:46 AM (in response to Michael Gillespie)Hi Michael, if it is true that null values skew the calculation that would be verry troublesome. This means that Tableau is inconsistent in its calculations and cannot be used for exact purposes, is this what you are implying?

7. Re: sheet calculation median and table calculated median do not match
Michael Gillespie Nov 15, 2018 4:54 AM (in response to Joost Valk)No, not at all. That would be a rather dramatic conclusion. I'm just looking for reasons as to why those 2 numbers might be different.
There are a lot of filters applied to both of those vizualizations  I'm more inclined to think that's where the problem lies. I need to spend a little more time looking at the workbook before I can give you a better answer.

8. Re: sheet calculation median and table calculated median do not match
Michael Gillespie Nov 15, 2018 5:14 AM (in response to Michael Gillespie)I believe I have an answer for you. I don't pretend to understand the underlying data but I think this is what is going on.
On the bar graph viz where the median value is 11.20, you appear to be calculating the median value of the pertargetcompany median (in other words, determine the median EBITDA at the Target Company level, THEN calculate the median of those individual Target Company medians).
On the onenumber EBITDA calculation where the value is 11.56, you are calculating the median value of the entire data set.
That will indeed give you 2 different answers.
Remember that Tableau performs all its calculations relative to the measures and dimensions that are in the specific view you are performing the calculation in. You will need a Level of Detail calculation for the Median value in the Target Company viz.

9. Re: sheet calculation median and table calculated median do not match
Joost Valk Nov 15, 2018 5:50 AM (in response to Michael Gillespie)Thanks for the rapid response, I'm going to have a look at it.

10. Re: sheet calculation median and table calculated median do not match
Ciara Brennan Dec 6, 2018 7:05 AM (in response to Joost Valk)Joost Valk wrote:
Thanks for the rapid response, I'm going to have a look at it.
Hi Joost
Just checking if this is now resolved?
Thanks, Ciara

11. Re: sheet calculation median and table calculated median do not match
Joost Valk Dec 18, 2018 1:26 AM (in response to Ciara Brennan)Dear Ciara,
Thank you for the follow up. The issue has not been resolved yet. In response to Michael's suggestion, the median calculation of a single value should be equal to that same value (median of 21 = 21) so I do not see how this should effect the median calculation and result in a different median. Moreover the data used in the bar graph is not calculated but are static medians drown from an external data set so there should be no difference when calculating the median from the data set directly or filling the bar graph with the entire data set. I hope I'm missing something.
Kind regards,
Joost