5 Replies Latest reply on Sep 27, 2016 2:30 PM by Shinichiro Murakami

# Table calculation at a deeper level than the current view?

Hey everyone!

This is actually my first post on the forum, I used to look all over the internet to get answers, but this one has been tricky ! O:)

Let me describe the issue :

I've got trains departing from a station at different hours. The only thing I know is the departure timestamp, and I'm looking for the time interval between 2 departures...

I managed to get it with a table calc thanks to the difference between a row and the previous one, but here is the problem :

As you can guess, having this level of granularity gives me too many marks. I would like to get the average time difference for each hour, by putting aside the minutes, but it breaks my table calculation, which is then referring to the previous hour instead of minute...

Therefore, the question is : Can we perform a table calculation at a deeper level than the view ?

Thank you in advance!

• ###### 1. Re: Table calculation at a deeper level than the current view?

Welcome to the community!  Hugo.

BTW, it's always much more helpful if you can add your packaged workbook.

It's always quite difficult to investigate the issue only from the description.

We always need data!

Thanks,

Shin

• ###### 2. Re: Table calculation at a deeper level than the current view?

Thank you for your answer, I just made a sample of my dataset so that you can understand what I'm trying to do...

As you can see, it works pretty well with Minutes in the columns shelf, but the table calculation doesn't work if i remove it.

I would like to have the average of the measures I have, for each hour.
Again, thank you very much!

• ###### 3. Re: Table calculation at a deeper level than the current view?
1 of 1 people found this helpful
• ###### 4. Re: Table calculation at a deeper level than the current view?

Thank you Shin, this is indeed working properly, at least for the upper granularity
I wonder if tableau is able to view an even broader scope with this level of table calculation or if we have to calculate it before integrating to Tableau. This is not the first time I encounter such an issue...

Again, thank you very much!

• ###### 5. Re: Table calculation at a deeper level than the current view?

In your case, you used table calculation to calculate the difference of two time stamp.

Adding one more layer of table calculation is quite troublesome.

Then I recommend that you handle the first layer of calculation before bringing data into Tableau.

Or Tableau can use Worksheet's data as data source, if it's to use the data which is dynamically updated.

Thanks,

Shin