Hi @Rad ,
By Date hierarchy I meant, you can create simple date table in your database using standard SQL with sequence of dates that cover the entire date period required for the analysis with fields such as day of the week, workdays, weekends, quarters, months, years, or custom quarter you would like to define. Here is quick look at it.
You can join it with your main table which hold all your transactions like the one i am doing with sales and use this dataset for analysis
I have one example here to take a look at -
Custom Quarter
You can copy analysis by clicking on the copy icon on left pane of this sample dashboard.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here.(Details on using Arena can be found here - QuickSight Arena )