Dynamic date and periods

Question & Answer
, , , , , , ,
1

I have dates in my database in this format “20240831” and I want to use filters in my dashboard where I can add monthly, quarterly, semi-annual, annually the calculated values ​​in which I wanted to make a calculated field but in a dynamic way comparing quarter by semester, etc…

2

Hello @Paduk1 , welcome to the QuickSight community!

I would recommend starting with parseDate:

From there you can create a time period parameter with specific values for the periods that you want to measure for i.e. day, week, month etc… Then you can apply that to a calculated field.

For example:

ifelse(
${TIMEPERIOD} = 'Day',
truncDate('DD', {parseDate_calc}), 
etc....,
NULL)

One note, semester is not a valid date period in QuickSight so you will have to hard code that into your calculated field.