How to create weekly date ranges based on custom date range selection?

I have created a date range filter (in calendar format), based on Start and End dates.

The intended output should be, as I click a range of dates from the filter, I would like to be able to break the range of days into disparate weeks.

For example, if I chose Feb 4th to Mar 3rd, it would show me 4 weekly lines of data (4th to 10th, 11th to 16th, 17th to 23rd, 24th to 3rd).

However, for now, when I select this range of dates, I get pre-populated outputs in my Pivot table. The Pivot table uses Date column (set to Week setting).

Does anyone know how this can be implemented ?


You need add date column in a group and select it as given below image.

Hi, @Dinesh. Did @Naveed’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like