Skip to main content

Hello Tableau Users,

 

I'm facing a small issue in concatenating a dimension with Aggreagted date field, its throwing me a error, yes I can see i'm mixing up two data types. because I have to append the max of the end to campaign display, is there any way where this functionality can be achieved. appreciate the help.  Thanks

 

concatenating Dimension and aggregated Date field

3 answers
  1. Mar 7, 2017, 5:11 PM

    Hi Kakani,

     

         Refer the below 2 suggestions and decide which one is working for you.

        

         ATTR[campaign_display]+":"+STR(MAX(IF [platform]="VOD" then [campaign_end_date] END))

     

         ATTR([campaign_display])+":"+STR(MAX(IIF([platform]="VOD", ([campaign_end_date]),NULL)))

     

         Hope this Helps!!

     

    Thanks,

    Dhruv Gupta

0/9000