Calculate no of registered users daily/weekly/monthly/yearly with calculated field in quicksight

Question & Answer
,
1

how to calculate no of registered users daily/weekly/monthly/yearly by using calculated field

2

@Shalini, assuming that you have flag to identify user-registration to calculate the count. QuickSight enables auto enables date hierarchy on date columns in charts/graphs as to change from year/quarter/month/day etc using right click. In case you want users to control the date granularity via filter control, create a parameter and attach that to a filter control with value list of your choice such as Day/Week/Month/Year and create a calculated field as below.
ifelse
(
${pSelectPeriod}=‘Day’,truncDate(“DD”,{Order Date}),
${pSelectPeriod}=‘Week’,truncDate(“WK”,{Order Date}),
${pSelectPeriod}=‘Month’,truncDate(“MM”,{Order Date}),
truncDate(“YYYY”,{Order Date})
)