Hi I am trying to create this view in quicksight. I want to know how i can bring month, ytd and weeks in different columns for a metric. Currently because of date hierarchy I am not getting separate columns.
hello @pspidadi,
Please refer the SS.
I think you can achieve this by this method.
I hope you will get some idea on this.
Best,
Vaibhav.
What is the method here? I can just see screenshot. But how do I achieve this?
Hello @pspidadi ,
You have to create 3 different tables for that and for each table, you have to set the different date aggregation.
Like 1 table : set day week wise aggregation
for table 2 : set month wise aggregation
for table 3 : set year wise aggregation
Best Regards,
Vaibhav.