Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
May 30, 2015, 10:01 AM

Use of Attr Function

Hi All

 

I want to use following formula

 

Attr([Temp])

 

Where [Temp ] is a aggregate variable means its definition is:

 

if max([Last3Month])=(min([Last3Month]))

 

then [Id] end

 

so it is not allowing me to use Attr

please share your thoughts on this

 

Thanks

Ghanshyam

1 answer
  1. Rody Zakovich
    May 30, 2015, 3:45 PM

    Hello Ghanshyam,

     

    The issue you are having is [temp] is itself an aggregate function. Tableau does not allow you to do an aggregate of an aggregate at a row level.

     

    You can, however, apply window functions to aggregates, as these are applied after row level calculations are evaluated.

     

    Are you able to attach an example workbook? I would be more than happy to help you with your requirement, and see if there is an alternative method to achieving it.

     

    Regards,

    Rody

Write an answer...
0/9000