Hello! I want to add a filter inside the dashboard where the viewer can easily select the week that they want to filter the data, without setting start and end date. For example navigating through the weeks with arrows <,>. Also if it possible to select the date intervals (ex. weekly, monthly, daily)
Hi @anasia
You can create custom parameter control with fixed values. Like Week 1 to 52 and use them in calculated field to check the condition if Week number of date filed matches the selected week number from control and set true. and apply the calculated field as filter to limit only True conditions.
Calc to get week : truncDate(“WK”, )
Here is the demo central link for dynamic date aggregation
https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Switch-Date-Aggregation
1 Like