Skip to main content

Hi All,

I am creating a new Tableau report which has the data in below format.

Deal,Contract,Date1(Date&Time),Date2

111,222,15-04-2020 06:18:55.653,26-10-2020

111,222,15-04-2020 06:18:55.720,26-10-2020

 

The requirement is to display date alone instead date&time.

 

When I change the Date1 type from date & time to date then it automatically group and display this as one record as below.

 

Deal,Contract,Date1,Date2

111,222,15-04-2020,26-10-2020

 

Whereas the requirement is to display it as 2 records as below.

Deal,Contract,Date1,Date2

111,222,15-04-2020,26-10-2020

111,222,15-04-2020,26-10-2020

 

Can you check and suggest?

Thanks in advance.

 

Regards,

Pradeep.

5 respuestas
  1. 17 nov 2020, 14:52

    Hello @Pradeepkumar R​ ,

    Include the datetime column on rows, right click the pill, and unselect "Show Header". This will hide the column.

    See attached.

    @Robert Breen​ 

0/9000