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개
  1. 2017년 3월 7일 오후 5:11

    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