Can someone please explain the ATTR Function in Tableau

Question

I know that the ATTR function is used for aggregation, but can someone explain it in simple terms?

can you please elaborate? – Enamul Hassan Dec 22 '15 at 13:02 — Enamul Hassan, Dec 22 '15 at 13:02

score 8 · Answer 1 · answered Dec 22 '15 at 14:22

8

In the most simplest of terms, ATTR returns a value if it is unique, otherwise it returns "*". I think you'll find this link helpful with examples.

https://www.interworks.com/blog/tcostello/2014/05/15/attr-tableaus-attribute-function-explained

answered Dec 22 '15 at 14:22

Bernardo

2,907
1
8
16

Agreed. This was helpful. – gireesh4manu Mar 07 '19 at 08:58

score 3 · Answer 2 · edited Mar 09 '17 at 21:35

3

You cannot mix aggregate and non aggregate comparisons in tableau, you have to use ATTR, for e.g. if ATTR(segment) ='Corporate' then sum(sales)

edited Mar 09 '17 at 21:35

Community

1
1

answered Apr 26 '16 at 03:41

S123DB8

335
3
16

score 0 · Answer 3 · answered Sep 24 '20 at 05:00

ATTR is like using an already aggregated field for comparison with another aggregated field. Measures are taken as aggregated fields while dimension's aren't. If you have created a field which is already aggregated and still you want to use this field as measure it will be shown as ATTR as it cannot be further aggregated but is behaving like it has.

Can someone please explain the ATTR Function in Tableau

3 Answers3

Linked