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
Dec 3, 2019, 9:47 AM

Visualizing New Clients

YearClients2017A2017A2018B2019B2019C

 

Hi all,

 

I am trying to count and visualize clients that only started doing business with us this year, i.e. Client C.

 

How would you do that?

 

Thanks,

Johnny

5 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Dec 3, 2019, 11:58 AM

    Hi, Johnny

     

    Try to create a calculation field as below

     

    {Fixed [Clients]:min(Year)} = Year(Today())

     

    And add this to filter and select true, then your date will show client C only

    Hi, Johnny Try to create a calculation field as below {Fixed [Clients]:min(Year)} = Year(Today()) And add this to filter and select true, then your date will show client C only Hope this helps ZZ

     

    Hope this helps

     

    ZZ

Write an answer...
0/9000