知識庫

Show the Latest Date of Data Source as Default Value in Parameter


發佈時間 : 13 Oct 2020
上次修改日期 : 09 Dec 2022

問題

How to set a parameter to show the latest Date in the data source.

環境

  • Tableau Desktop 2020.1 and later

答案

Use Dynamic Parameter (available in Tableau Desktop 2020.1 and later).

1. Create a calculation field to get the latest date in the data source
Field name: ! Max Date
Calculation: {MAX([Order Date])}

2. Create a Parameter, set the [Data type] to [Date], and set [Value when workbook opens:] to [! Max Date]
這篇文章是否解決了問題?