Skip to main content
yeoksong Ng 님이 #Tableau Desktop & Web Authoring에 질문했습니다

I want to count the number of account between sales team.

The rule is simple. If there is an account that is sold by more than one sales team, I would consider it as common account.

However, the rule only applies if the sales is within the last 365 days from the measured date.

I use the followings to count the Common accounts

My problem is, I can only count this at a single point of time.

How do I count this over a period of time? The 365 days window will have to move.

답변 1개
  1. 2019년 5월 24일 오전 5:50

    Yeok:

     

    This should work :

     

    COUNTD(

    IF { FIXED [Account Name] : COUNTD(if DATEDIFF('day',[Date],today())<365 then [Sales Rep Team] end)}>1 THEN [Account Name] END

    )

    Thanks,

    AB