All topics
Business intelligence / 41 guides
Amazon QuickSight
Date, logic, table, level-aware and period-to-date calculations in QuickSight, now called Amazon Quick Sight.
Date calculations
- How to calculate the first day of a month in QuickSight
- How to calculate the last day of a month in QuickSight
- How to calculate the first day of the week, quarter or year in QuickSight
- How to calculate the difference between two dates in QuickSight
- How to add or subtract days, months or years in QuickSight
- How to extract the year, month or day from a date in QuickSight
- How to convert a string to a date in QuickSight
- How to format a date as text in QuickSight
- How to convert a Unix timestamp to a date in QuickSight
- How to convert an Excel serial date to a date in QuickSight
- How to count working days between two dates in QuickSight
- How to filter the last N days relative to today in QuickSight
Conditional logic
Table calculations
Level-aware calculations
Text and parameters
Period-to-date
- How to calculate YTD and MTD in QuickSight
- How to calculate QTD and WTD in QuickSight
- How to compare YTD with prior year YTD in QuickSight
- How to calculate YTD growth % vs prior year in QuickSight
- How to handle 29 February in a prior year comparison in QuickSight
- How to compare an incomplete month with the same days of last month in QuickSight
- How to calculate a rolling 12-month total in QuickSight
- How to calculate a running total that resets every year in QuickSight
- How to calculate fiscal year to date in QuickSight
- How to let users pick the "as of" date for YTD in QuickSight