CODEWITHSUNDEEP
calculated-fieldamazon-quicksightqliksense
Karan Goyal
Karan Goyal

Reputation: 11

Quicksight calucalted field /YTD calculations

Sum($(vSetYTD) ResidentDays) this calculated field is doing sum of "residentDays' while setting YTD function(This expression is used in qlik sense/qlikview.) Now in quicksight how to set a similar YTD function so that if I have given a filter/control of date(Year).My YTD changes automatically to that year. Example 2021 YTD of sum(residentdays)=80% after selecting the year as 2020 I get YTD of 2020 year. Looking for positive response

Upvotes: 0

Views: 597

Answers (1)

valkyrie55
valkyrie55

Reputation: 505

For Period to date calculations in quicksight: periodToDateSum()

YTD: periodToDateSum(Sales, Order_date, YEAR)

MTD: periodToDateSum(Sales, Order_date, MONTH)

Upvotes: 0

Related Questions