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?

Cosgrove

can you please elaborate? – Dundee

Answer 1

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

Zedoary

Agreed. This was helpful. – Zoonosis

Answer 2

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)

Leveloff

Answer 3

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.

Weinstein