Skip to main content
GruppiJapanDomanda di Tableau Community Forums Member (Inactive)
Tableau Community Forums Member (Inactive) (Salesforce) ha fatto una domanda in Japan
5 dic 2023, 10:44

I need to create a report with the custom sql query , where I don't see date column in the data pane, so i have inserted start date ,end date parameter in the query

The parameters are working fine and i'm getting the desired output,but ,I have to also show the dates after End date filter for comparison of the dates till Today(). as shown in the below format , can someone help with thisI need to create a report with the custom sql query , where I don't see date column in the data pane, so i have inserted start date ,end date parameter in the query 

4 risposte
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    6 dic 2023, 06:50

    I think your current parameter setting is the below. In this case, end date is only specified date.

    I think your current parameter setting is the below. In this case, end date is only specified date. First, create a calculated field as below. and, selectFirst, create a calculated field as below.

    imageand, select "today" you created in parameter.imageEnd date will be displayed as "today". So you always get data up to "today".

    Is this what you want to do?image

Scrivi una risposta...
0/9000