CODEWITHSUNDEEP
tableau-apitableau-desktop
user458
user458

Reputation: 409

Why total ignores filter?

I have a row with calculated field - TOTAL([num_launches]), where num_launches is also calculated field = SUM([count])

When I filter launches by date of the launch(which is not in the rows), leaving only 5 of 10 launches e.g., total doesn't change. However, when I filter by the name of launches it works... Is that the common problem and maybe someone knows how to solve it

Upvotes: 1

Views: 115

Answers (1)

Alex Blakemore
Alex Blakemore

Reputation: 11919

A quick fix is to select your field on the filter shelf and “add it to the context”. Context filters will be applied early.

To better understand the timing of filters, calculations and how to obtain the results you wish, learn about Tableau’s “order of operations”. There is a brief discussion in the on-line help, and more in depth info in the training and conference videos.

Upvotes: 2

Related Questions